Are you sure u have journoNatOpt.journoid = '' records? select count(*) ....where journoNatOpt.journoid = '' If not, maybe IS NULL instead of = '' will help.
----- Original Message ----- From: "David Phipps" <[EMAIL PROTECTED]> To: "MySQL List" <[EMAIL PROTECTED]> Sent: Monday, February 03, 2003 8:46 AM Subject: Problem with a query - help!!? > 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!! > > > --------------------------------------------------------------------- > 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 > --------------------------------------------------------------------- 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