Re: SET something to NULL if value not matched.
Posted by:
Paul Smith
Date: August 03, 2005 10:04PM
Okay, I apparently figured it out. If anyone cares:
SELECT title,developer,publisher,
IFNULL(dsc.description, ' ') as description
FROM info
LEFT JOIN dsc ON info.id = dsc.id AND dsc.language = "j"
AND info.id = "100"
Subject
Written By
Posted
Re: SET something to NULL if value not matched.
August 03, 2005 10:04PM
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.