Sign In/My Account | View Cart  

advertisement

AddThis Social Bookmark Button

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