Re: Query: WHERE NOT
| From: | B.C. Lance | Date: | Sat, 14 Sep 2002 07:38:22 +0000 |
| Subject: | Re: Query: WHERE NOT | ||
| References: | 1 2 3 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-116361@lists.php.net to get a copy of this message | ||
try this:
SELECT *, bild_db.id AS bid FROM bild_db, bildreferenz_db WHERE (bild_db.id <> bildreferenz_db.bild_id) GROUP BY bild_db.id
NOT is represented using "<>" instead of "!="
--lance
Sascha Braun wrote:
SELECT *, bild_db.id AS bid FROM bild_db, bildreferenz_db WHERE (bild_db.id != bildreferenz_db.bild_id) GROUP BY bild_db.id They are all not working, I'm going to RTFM (O;?