Hallo!
Is it possible to combine two tables in a query so that if there is one or more entries in the second table containing the ID of lines of the first table those lines of the first table should not be contained in the outpu.
e.g.:
tab1: id, ....
tab2: id, tab1_id,...
If there are one or more entried of in tab2 containing the id of tab1 in the field tab1_id, then the query should not output those line of tab1. Something like:
select tab1.* from tab1, tab2 where tab1.id != tab2.tab1_id
What's the correct query
Thanks,
Matthias
Is it possible to combine two tables in a query so that if there is one or more entries in the second table containing the ID of lines of the first table those lines of the first table should not be contained in the outpu.
e.g.:
tab1: id, ....
tab2: id, tab1_id,...
If there are one or more entried of in tab2 containing the id of tab1 in the field tab1_id, then the query should not output those line of tab1. Something like:
select tab1.* from tab1, tab2 where tab1.id != tab2.tab1_id
What's the correct query
Thanks,
Matthias