which one is best to display records?

I have to show report whose data is based on many tables. Which one is best to display the records using outer join or subquery ?

-----------------------
suresh

Outer join is the choice. By the way I am curious... How do you use subqueries to join many tables???? Each time write a subquery for each and every join condition?

Never heard using subqueries for join of big tables.

-Kalayama

Joins are stronger and better than sub-queries.:eek:

But the thing is, its very difficult to construct queries with joins.:mad: