Query: Subtraction one set from another set in MySQL

Codes here !

Moderators: egami, macek, gesf

Post Reply
Elena Mitovska
New php-forum User
New php-forum User
Posts: 13
Joined: Tue Nov 12, 2002 12:11 pm
Location: Ukraine

Mon Dec 09, 2002 12:08 am

One of ways you can select those IDs from one table that are not contained in other table is:

select distinct A.ID from A LEFT OUTER JOIN B ON A.ID=B.ID WHERE B.ID is NULL

This select statement will create pair of corresponding rows from both tables, those IDs of table A, that are not contained in table B, will have NULL matching values from table B.
best regards,
Elena Mitovska,
AlarIt company

Post Reply