> Thanks but I think subselect is not possible with MYSQL.
You're right. Here's a MySQL compatible alternative:
table1.* FROM table1
LEFT JOIN table2 ON table1.id=table2.id
where table2.id IS NULL
From the MySQL manual on sub-selects at:
Sent: Mon 11/12/2001 12:20 AM
To: Gonzalez, Lorenzo; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] SQL query
Thanks but I think subselect is not possible with MYSQL.
----- Original Message -----
From: Gonzalez, Lorenzo <[EMAIL PROTECTED]>
To: Pierre <[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
> select * from table1 where table1.id not in (select
> -----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
> 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
> Thank for helping me.