Thanks but I think subselect is not possible with MYSQL.
----- Original Message -----
From: Gonzalez, Lorenzo <[EMAIL PROTECTED]>
To: Pierre <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, November 12, 2001 1:08 PM
Subject: RE: [PHP-DB] SQL query
> in other RDBMs this is easily done with a subselect - don't know if it's
> doable in MySQL or not, someone else can confirm, or you can try it
> select * from table1 where table1.id not in (select table2.id);
> -----Original Message-----
> From: Pierre
> Sent: Sun 11/11/2001 10:01 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] SQL query
> I have two tables, one call category, the other chapter
> Category table
> Chapter table
> I would like to get the list of names of the Category table that
> are NOT present in the Chapter table.
> On this example, I should find "b" and "d".
> Is it possible to get it directly from a SQL query ? (I am using
> Thank for helping me.
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]