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
I want this query to give me a list of all article titles from a content table (t1) and the author's name from a people table (t2) where, the author ID from t1 matches that of t2, AND the article is either from Category 1 or Category 2. What I get instead, though, is every possible combination of article titles and author names from both tables. So, if there were 10 authors in t2, each title would be listed 10 times, once with each author name.
Should I be using a different JOIN syntax? Am I totally mis-using the OR operator?
Note that if I only want results from one category (i.e.: SELECT t1.title, t2.auth_name FROM t1, t2, WHERE cat_id = 1 AND t1.auth_id = t2.auth_id) everything works just fine.
Thanks for any help,
Sam
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
