Legal sql

From: Date: Mon, 21 Oct 2002 22:34:05 +0000
Subject: Legal sql
Groups: php.db 
Request: Send a blank email to php-db+get-22566@lists.php.net to get a copy of this message
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/

« previous php.db (#22566) next »