RE: Help with Join SQL

John Dunn
Product Consultant
Sefas Innovation Limited.
Tel:   + 44 (0) 117 910 0529
www.sefas.com

-----Original Message-----

From: Dimensional DBA [mailto:dimensional.dba_at_comcast.net] Sent: 02 February 2016 13:05
To: John Dunn; oracle-l_at_freelists.org Subject: RE: Help with Join SQL

Try something like this.

from tab3 LEFT OUTER JOIN tab1 ON tab1.customer = tab3.customer LEFT OUTER JOIN tab2 ON tab2.customer = tab3.customer;

Some explanation for ANSI SQL Standard relative to Oracle SQL for OUTER JOINS:

https://blogs.oracle.com/optimizer/entry/outerjoins_in_oracle
http://www.oratechinfo.co.uk/ansi_joins.html
http://www.orafaq.com/node/2618

Matthew Parker
Chief Technologist
Dimensional DBA
425-891-7934 (cell)
D&B 047931344
CAGE 7J5S7
Dimensional.dba_at_comcast.net
View Matthew Parker's profile on LinkedIn

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of John Dunn
Sent: Tuesday, February 02, 2016 3:14 AM To: oracle-l_at_freelists.org
Subject: Help with Join SQL

I need to convert the following Oracle specific code to standard SQL (LEFT OUTER JOINS?)

           
            from tab1,tab2,tab3 
            where 
               tab1.customer(+) = tab3.customer and 
               tab2.customer(+) = tab3.customer ;

Can anyone help?

--

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

--

http://www.freelists.org/webpage/oracle-l Received on Tue Feb 02 2016 - 16:36:08 CET