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
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
[COLOR="Blue"][SIZE="2"]"If you are not living on the edge of your life, you are wasting space"[/SIZE][/COLOR]
Someone says "Impossible is nothing". The man next him says "Let me see you licking your elbow tip!"
Joins are stronger and better than sub-queries.
But the thing is, its very difficult to construct queries with joins.
Lack of WILL POWER has caused more failure than
lack of INTELLIGENCE or ABILITY.
-sutnarcha-