RE: Help with Join SQL
Date: Tue, 2 Feb 2016 05:05:28 -0800
Message-ID: <002b01d15dba$6461db50$2d2591f0$_at_comcast.net>
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 - 14:05:28 CET