ONJava.com -- The Independent Source for Enterprise Java
oreilly.comSafari Books Online.Conferences.


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

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