Women in Technology

Hear us Roar


Subject:   Outer Joins With Oracle
Date:   2005-10-05 03:41:55
From:   outerjoins
Response to: Outer Joins With Oracle

Hi,
I've used 2tables holding june month and august month data. In august month i've got (n+1) records whereas in june month n records. On using outer join for august and june month, i got same number of records as their corresponding tables.


select a.* from aug a, jun b where b.ASST_NO=a.ASST_NO(+); -- getting jun table record count


select a.* from aug a, jun b where b.ASST_NO(+)=a.ASST_NO; -- getting aug table record count

Recommended for You
 
Sign up today to receive special discounts,
product alerts, and news from O'Reilly.
Privacy Policy >
View Sample Newsletter >