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

On Oct 20, 12:14 pm, olaf870 <olaf...@gmail.com> wrote:
> 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.