Conditions on left join
Posted by:
Shaun Day
Date: March 29, 2005 04:51AM
I'm having trouble constructing this left join query.
I want to retrieve all rows from tProducts, and relevant matches from pictures, however what I have got just jams up the server and I have to restart. Am I doing it wrong?
SELECT prodCode, prodName
FROM tProducts LEFT JOIN pictures
ON productID = relProdId
AND prodCode = 'SF2'
Subject
Written By
Posted
Conditions on left join
March 29, 2005 04:51AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.