OR doesn't work logically (simple but urgent)

[rastkocvetkovic]

This is my SQL query:

SELECT * FROM News WHERE (id IN (SELECT news_id FROM LinkingCategoriesNews WHERE news_id = 1) AND active= 1) OR (id = 82) ORDER BY date DESC

I suppose that it should firstly select all News that have ID's in LinkingCategoriesNews. That works, but it is problem that it just selects those. The News with id = 82 isn't included in output. Isn't that how OR is supposed to work? What seems to be the problem? Thanks in advance!

P.S.: I use MS Access over ODBC.

 

[PruSQLer]

Without testing this out, I think you need to have the entire OR clause enclosed in parens. You have your AND statement enclosed but not the OR.

 

[rastkocvetkovic]

Hmm, after your replay I also tried this:

SELECT * FROM News WHERE ((id IN (SELECT news_id FROM LinkingCategoriesNews WHERE category_id = 1)) AND (active= 1)) OR (id = 51) ORDER BY date DESC

But the result is the same. Did you mean this or something else?

 

[r937]

the syntax is fine, it should return the row from news with id=82, and if it doesn't, then do this:

based on how it's currently coded with the OR, break the query apart into two queries:

SELECT 'query 1'
     , News.* 
  FROM News
 WHERE (id IN 
         (SELECT news_id 
            FROM LinkingCategoriesNews 
           WHERE news_id = 1) 
   AND active= 1)

and

SELECT 'query 2'
     , News.* 
  FROM News
 WHERE (id = 82)

this should tell you all you need to know   ;-)

rudy
[URL unfurl="true"]http://rudy.ca/[/URL]