RE: [PHP-DB] SQL query

[Gonzalez, Lorenzo]

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