T0
c1 | c2 |
a | b |
c | d |
T1
c1 | c2 |
b | a |
c | e |
Result
c1 | c2 |
c | d |
c | e |
Statement:with tt as (
select c1,c2,c1||c2 as c3 from t0 a where not exists (select 1 from t0 b where b.c1||b.c2=a.c2||a.c1)
union all
select c1,c2,c1||c2 as c3 from t1 a where not exists (select 1 from t1 b where b.c1||b.c2=a.c2||a.c1))
select * from tt
minus
select * from tt group by c1,c2,c3 having count(1)>1
minus