Hi, I think the problem is that your assuming that journoNatOpt.journoid is '' (empty) when journoDetails.journoid has no entry in journoNatOpt. But that's not true, the value is NULL.
So, try replacing AND journoNatOpt.journoid = '' with AND journoNatOpt.journoid IS NULL On Mon, 2003-02-03 at 13:46, David Phipps wrote: > Hi, > > I am new to this list so I apologise if this is not the place to post this > message. > > I am in the final stages of completing a project and I have one query that > is causing problems. > > I need the query to get a story or stories from the story table and > journalists from the journalist table where their respective id is not > present in a table which links the journoid to a national option table and > the storyid to the national option table. > > So far I have: > > SELECT storySub.storyid, storySub.headline, journoDetails.journoid, > journoDetails.journoName, journoNatOpt.journoid AS natJid > FROM releaseManager, journoDetails LEFT JOIN journoNatOpt ON > journoDetails.journoid = journoNatOpt.journoid, storySub > WHERE storySub.isNational = 1 > AND journoDetails.isNational = 1 > AND journoDetails.isApproved = 1 > AND journoNatOpt.journoid = '' > AND releaseManager.storyid = storySub.storyid > AND releaseManager.isReleased = 1 > AND releaseManager.immediateRelease = 0 > AND releaseManager.releaseTime BETWEEN #CreateODBCTime(Now())# AND > #CreateODBCTime(DateAdd("n", 30, Now()))# > AND releaseManager.releaseDate BETWEEN #CreateODBCDateTime(Now())# AND > #CreateODBCDateTime(DateAdd("h", 24,Now()))# > > The above query seems to have trouble when I insert the following: AND > journoNatOpt.journoid = '' > If I remove this line then I see all the of national stories and any > national journalists which is fine except that some of the stories and > journalists are actually linked to a national option. What I want to have > is all stories and journalists that are national but where they are not > linked to a national option. > > If this makes any sense and you can see what I am doing wrong then please > help!! > > Thanks in advance > > Dave Phipps > MySQL new guy!! -- Diana Soares --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php