Re: SQL query

Thanks but I think subselect is not possible with MYSQL. Pierre ----- Original Message ----- From: Gonzalez, Lorenzo <gonzalez@gltg.com> To: Pierre <p.marcandella@justtransfer.com>; <php-db@lists.php.net> 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: php-db@lists.php.net > 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 > > >