[PHP-DB] Legal sql

2002-10-21 Thread Gerard Samuel
Im looking for another opinion on an sql statement. SELECT sc.col1 FROM search s, search_content sc WHERE s.word = 'mysql' AND s.wid = sc.wid OR s.word = 'apache' AND s.wid = sc.wid; I had to use s.wid = sc.wid twice in the sql for the query to work properly. Is this the legal, correct way to

Re: [PHP-DB] Legal sql

2002-10-21 Thread Gerard Samuel
Thanks for the reply. The parentheses are noted. Meantime, I did some reading and came up with this - SELECT sc.col1 FROM search s, search_content sc WHERE s.word IN ('apache', 'mysql') AND s.wid = sc.wid Thanks for the tip. DL Neil wrote: Gerard, Im looking for another opinion on an sql