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
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