Re: Left Join Problem
Bob Field Wrote:
-------------------------------------------------------
> The use of LEFT JOIN means that all rows from
> setup_main are included in the output regardless
> of any rows retrieved from output1, output2 and
> output3. I am not understanding the goal of this
> query, can you elaborate? I guess you somehow want
> to use the date information in output1, output2
> and output3 to control the rows retrieved from
> setup_main.
Yes, the result from setup_main is controlled by date info from output1, output2 and output3...
was my usage of left join correct or am i doing it totally wrong?
cheers
Subject
Views
Written By
Posted
2580
August 22, 2006 11:30PM
1772
August 23, 2006 09:00AM
Re: Left Join Problem
1763
August 23, 2006 06:53PM
1696
August 23, 2006 07:12PM
1886
August 23, 2006 11:01PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.