Sagewire Logo

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



Programming | Sports | Autos

copyright 2006
Valid XHTML 1.0 Transitional