Re: using OR in select statement with distinct results

[Sam Folk-Williams]

Thanks everyone, I suspected it was something quite simple.

Sam

Matt W wrote:

----- Original Message -----
From: "Paul DuBois"
Sent: Thursday, September 18, 2003 8:17 PM
Subject: Re: using OR in select statement with distinct results
 

At 7:47 PM -0500 9/18/03, Sam Folk-Williams wrote:
   

Hi,

I keep having this fundamental problem. It seems like this should be
easy enough, but whenever I have a query where I'm using OR in the
WHERE clause and the query is performed on multiple tables, I get
strange results. For example:
SELECT t1.title, t2.auth_name FROM t1, t2, WHERE cat_id = 1 OR
cat_id = 2 AND t1.auth_id = t2.auth_id
     

You probably should use parentheses in your WHERE clause to explicitly
group terms the way you want them evaluated.
   

Yeah, like

WHERE (cat_id=1 OR cat_id=2) AND ...

However, I just replied to say that it would be easier and cleaner
looking to use IN:
WHERE cat_id IN (1, 2) AND ...

:-)

Matt

 



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]