how to display single row result

Moved this thread from the "Best Practices" forum here and it's a duplicate of displaying a single row in a view, so closing it.

Also moved how to retrieve data from multiple table from "Regional User Groups" to "General Help" ...

@nady, please post your threads only once and in the relevant forum.