Re: Multiple join and Where clause
According to your sample you don't want to filter which rows to retrieve, but which to join, so the checks for 'expected' and 'final' should be moved into the join condition. And following the first row in the example result set, you also want to move the date check into the join condition for table2.
I couldn't figure out what the last row in the example means (what kind of date is "1"?). Is that just a typo or does it have some special meaning?
Subject
Views
Written By
Posted
42762
November 15, 2006 05:13AM
Re: Multiple join and Where clause
6859
November 22, 2006 04:20PM
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.