Re: outer join between parent-child, not null and FK constraints
From: amonte <ax.mount_at_gmail.com>
Date: Sat, 26 Jan 2013 08:54:05 +0100
Message-ID: <CABV7K9vHak=V-CjiNbrP3_-5WRpHuXPhLN4ygiOnCuGDBAddEg_at_mail.gmail.com>
Hi David
I am talking about this query
Date: Sat, 26 Jan 2013 08:54:05 +0100
Message-ID: <CABV7K9vHak=V-CjiNbrP3_-5WRpHuXPhLN4ygiOnCuGDBAddEg_at_mail.gmail.com>
Hi David
I am talking about this query
SELECT "EMP"."ENAME" "ENAME","DEPT"."DNAME" "DNAME" FROM "BING"."EMP"
"EMP","BING"."DEPT" "DEPT" WHERE "EMP"."DEPTNO"="DEPT"."DEPTNO"*(+)*
and not
SELECT "EMP"."ENAME" "ENAME","DEPT"."DNAME" "DNAME" FROM "BING"."EMP"
"EMP","BING"."DEPT" "DEPT" WHERE "EMP"."DEPTNO"*(+)*="DEPT"."DEPTNO"
I know to output all dept tables you need outer join, I was talking about
the reverse
-- http://www.freelists.org/webpage/oracle-lReceived on Sat Jan 26 2013 - 08:54:05 CET