select *
from onetable o left join anothertable a
on o.id = a.id
where a.id is null
do you have the other case ? ID in anothertable but not in onetable ?|||
Maybe something like:
select id#
from newTable a
where not exists
( select id#
from firstTable b
where a.id# = b.id#
)
No comments:
Post a Comment