MySQL Forums
Forum List  »  General

Re: query help
Posted by: Sean Nolan
Date: March 30, 2005 05:03PM

Try this
SELECT conferences.*
FROM conferences
LEFT OUTER JOIN restricted ON conferences.conf_id = restricted.conf_id
WHERE restricted.uid = 'bloggs' AND restricted.conf_id IS NULL AND conferences.subject = 'topic';

Sean

Options: ReplyQuote


Subject
Written By
Posted
March 29, 2005 02:31PM
Re: query help
March 30, 2005 05:03PM
April 12, 2005 01:05PM


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.