Detect not exitistant
2 Message(s) by 2 Author(s) originally posted in mysql discussion
| From: olaf870 |
Date: Saturday, October 20, 2007
|
Hello
is there a quick MySql-Statement to select all rows from a
table which
dont have an correspondent
record with the same
key in a second
table?
kind regards
| From: ZeldorBlat |
Date: Saturday, October 20, 2007
|
wrote in message:
Hello
is there a quick MySql-Statement to select all rows from a table which
dont have an correspondent record with the same key in a second
table?
kind regards
select t1.id
from table1 t1
left outer
join table2 t2
on t1.id = t2.id
where t2.id is null
By the way, this has been answered many times before in this group.
Next Message: The Big Sleep