
In the above figure we read the "/" as "not
in" and the "∪"
as "union". In sum, we want the table comparison SQL to find:
select *
from
(
( select * from employee1
minus
select * from
employee2
)
union all
( select * from
employee2
minus
select * from
employee1
)
)
No comments:
Post a Comment