> 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
        >
        >
        >
        
        



Reply via email to