[PHP-DB] Legal sql

[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 do so.
Thanks

--
Gerard Samuel
http://www.trini0.org:81/
http://dev.trini0.org:81/



--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php