SQL-92 Outer Join support (lack)
From: Mike Rowland <102622.2522_at_CompuServe.COM>
Date: 1997/10/15
Message-ID: <efbXpUe28GA.186_at_ntdwwaaw.compuserve.com>#1/1
SELECT PERSON.NAME, PHONE.TYPE, PHONE.NUMBER FROM PERSON LEFT OUTER JOIN PHONE ON
SELECT PERSON.NAME, PHONE.NUMBER, ADDRESS.CITY, DEPENDANT.NAME FROM PERSON LEFT OUTER JOIN PHONE ON
PHONE.SSN = PERSON.SSN
Date: 1997/10/15
Message-ID: <efbXpUe28GA.186_at_ntdwwaaw.compuserve.com>#1/1
[Quoted] [Quoted] I have recently moved back to using Oracle 7.3 at a client. I have grown accustomed to using the SQL-92 syntax for outer joins. Oracle 7.3 has several limitations that prevent these from working. Does anyone have "good" work arounds for these questions?
- A left join that includes a literal selection?
SQL-92 example for "HOME" phone number:
SELECT PERSON.NAME, PHONE.TYPE, PHONE.NUMBER FROM PERSON LEFT OUTER JOIN PHONE ON
PHONE.SSN = PERSON.SSN AND PHONE.TYPE = 'HOME' WHERE PERSON.STATUS = 'ACTIVE'
ORACLE 7.3.3 EQUIVALENT? (Without using a view like "HOME_PHONE")
[Quoted] 2. Needing to list all a PERSON's available information SQL-92 example:
SELECT PERSON.NAME, PHONE.NUMBER, ADDRESS.CITY, DEPENDANT.NAME FROM PERSON LEFT OUTER JOIN PHONE ON
PHONE.SSN = PERSON.SSN
-- *****************************************************************Received on Wed Oct 15 1997 - 00:00:00 CEST
* The opinions expressed are solely the opinion of Mike Rowland *
* and not those of Cap Gemini America. *
*****************************************************************