Re: Query: WHERE NOT
| From: | Sascha Braun | Date: | Sat, 14 Sep 2002 00:07:56 +0000 |
| Subject: | Re: Query: WHERE NOT | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-116329@lists.php.net to get a copy of this message | ||
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;?
----- Original Message -----
From: "Jim Bailey (TeamB)" <jbailey1@houston.rr.com>
To: "Sascha Braun" <saschabraun@gmx.de>
Sent: Saturday, September 14, 2002 2:03 AM
Subject: Re: Query: WHERE NOT
> Try something like this:
>
> SELECT *, bild_db.id AS bid
> FROM bild_db, bildreferenz_db
> WHERE NOT(bild_db.id = bildreferenz_db.bild_id)
> GROUP BY bild_db.id
>
> Jim Bailey
> ----- Original Message -----
> From: Sascha Braun <saschabraun@gmx.de>
> Newsgroups: php.general
> To: PHP Mailingliste <php-general@lists.php.net>
> Sent: Friday, September 13, 2002 6:42 PM
> Subject: Query: WHERE NOT
>
>
> Need a Query like this, but this one doesn't work. So please help!
>
> SELECT *, bild_db.id AS bid FROM bild_db, bildreferenz_db WHERE bild_db.id
> != bildreferenz_db.bild_id GROUP BY bild_db.id
>
> Thanks
>
> Arrivedaci
>
> Sascha
>
>
>