SQL query
| From: | Pierre | Date: | Mon, 12 Nov 2001 03:01:06 +0000 |
| Subject: | SQL query | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-14241@lists.php.net to get a copy of this message | ||
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