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
