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

Reply via email to