Alex,
In your WHERE Clause you need to add (+)
SELECT A.ITEM1, B.ITEM2
FROM TABLEA A, TABLEB B
WHERE A.ITEM1 = B.ITEM1 (+)
This will return all items from A whether or not a join exists in B.
Pete
-----Original Message-----
From: Alex [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 25, 2000 13:20
To: CF-Talk
Subject: outer join syntax
whats the syntax for outer join in oracle?
____________________________________________________________________
Get free email and a permanent address at
http://www.netaddress.com/?N=1
----------------------------------------------------------------------------
--------------------
Archives:
http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe:
http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with
'unsubscribe' in the body to [EMAIL PROTECTED]
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]