> Thanks but I think subselect is not possible with MYSQL.
You're right. Here's a MySQL compatible alternative:
SELECT
table1.* FROM table1
LEFT JOIN table2 ON table1.id=table2.id
where table2.id IS NULL
From the MySQL manual on sub-selects at:
http://www.mysql.com/doc/A/N/ANSI_diff_Sub-selects.html
-----Original Message-----
From: Pierre
Sent: Mon 11/12/2001 12:20 AM
To: Gonzalez, Lorenzo; [EMAIL PROTECTED]
Cc:
Subject: Re: [PHP-DB] SQL query
Thanks but I think subselect is not possible with MYSQL.
Pierre
----- 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
> yourself...
>
> select * from table1 where table1.id not in (select
table2.id);
>
> -Lorenzo
>
> -----Original Message-----
> From: Pierre
> Sent: Sun 11/11/2001 10:01 PM
> To: [EMAIL PROTECTED]
> Cc:
> Subject: [PHP-DB] SQL query
>
>
>
> I have two tables, one call category, the other chapter
>
> Category table
> [id][name]
> [1][a]
> [2][b]
> [3][c]
> [4][d]
>
> Chapter table
> [id][FK_name]
> [1][a]
> [2][a]
> [3][c]
>
>
> 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
> MYSQL).
>
> Thank for helping me.
>
> Pierre
>
>
>