RE: Help with Join SQL

From: Dimensional DBA <>
Date: Tue, 2 Feb 2016 05:05:28 -0800
Message-ID: <002b01d15dba$6461db50$2d2591f0$>

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:

Matthew Parker
Chief Technologist
Dimensional DBA
425-891-7934 (cell)
D&B 047931344
View Matthew Parker's profile on LinkedIn

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

From: [] On Behalf Of John Dunn
Sent: Tuesday, February 02, 2016 3:14 AM To:
Subject: Help with Join SQL

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

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

Can anyone help?


-- Received on Tue Feb 02 2016 - 14:05:28 CET

Original text of this message