Re: outer join between parent-child, not null and FK constraints

From: amonte <ax.mount@xxxxxxxxx>
To: David Fitzjarrell <oratune@xxxxxxxxx>
Date: Sat, 26 Jan 2013 08:54:05 +0100

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


--
//www.freelists.org/webpage/oracle-l

References:
- outer join between parent-child, not null and FK constraints
  - From: amonte
- Re: outer join between parent-child, not null and FK constraints
  - From: David Fitzjarrell
- Re: outer join between parent-child, not null and FK constraints
  - From: amonte
- Re: outer join between parent-child, not null and FK constraints
  - From: David Fitzjarrell
- Re: outer join between parent-child, not null and FK constraints
  - From: amonte
- Re: outer join between parent-child, not null and FK constraints
  - From: Stephane Faroult
- Re: outer join between parent-child, not null and FK constraints
  - From: amonte
- Re: outer join between parent-child, not null and FK constraints
  - From: David Fitzjarrell

Other related posts:

» outer join between parent-child, not null and FK constraints- amonte
» RE: outer join between parent-child, not null and FK constraints- Ric Van Dyke
» Re: outer join between parent-child, not null and FK constraints- David Fitzjarrell
» Re: outer join between parent-child, not null and FK constraints- amonte
» Re: outer join between parent-child, not null and FK constraints- amonte
» RE: outer join between parent-child, not null and FK constraints- Ric Van Dyke
» Re: outer join between parent-child, not null and FK constraints- David Fitzjarrell
» Re: outer join between parent-child, not null and FK constraints- Saibabu Devabhaktuni
» Re: outer join between parent-child, not null and FK constraints- amonte
» Re: outer join between parent-child, not null and FK constraints- amonte
» Re: outer join between parent-child, not null and FK constraints- amonte
» Re: outer join between parent-child, not null and FK constraints- Saibabu Devabhaktuni
» Re: outer join between parent-child, not null and FK constraints- Stephane Faroult
» Re: outer join between parent-child, not null and FK constraints- David Fitzjarrell
» Re: outer join between parent-child, not null and FK constraints- amonte
» Re: outer join between parent-child, not null and FK constraints- David Fitzjarrell
» Re: outer join between parent-child, not null and FK constraints- Taral Desai
» Re: outer join between parent-child, not null and FK constraints - amonte
» RE: outer join between parent-child, not null and FK constraints- Iggy Fernandez
» RE: outer join between parent-child, not null and FK constraints- Iggy Fernandez