T1:
ID | FID1 | FID2
1  |  1   |  1
2  |  1   |  1
3  |  2   |  2
4  |  2   |  2
5  |  3   |  3

T2:
FID1 | FID2
 1   |  1
 2   |  2
 3   |  3
 3   |  3

with
  A (KID1, KID2)
    as
    (select KID1, KID2
     from T1
     order by ID)
select *
from A
rows (select (select count(*) from A) - count(*)
      from T2
      join A on A.KID1 = T2.KID1 and A.KID2 = T2.KID2)

select min(id), t1.fid1, t1.fid2
   from t1 left join t2 on t1.fid1=t2.fid1 and t1.fid2=t2.fid2
group by t1.fid1, t1.fid2
having count(distinct t1.id) > 1 or count(t2.fid1) = 0

T1:
ID | FID1 | FID2
1  |  1   |  1
2  |  1   |  1
3  |  1   |  1
4  |  2   |  2
5  |  2   |  2
6  |  2   |  2

T2:
FID1 | FID2
 1   |  1
 2   |  2

Из пример №1
T1:                  T2:
ID | FID1 | FID2     FID1 | FID2
1  |  1   |  1        попадает
2  |  1   |  1        1   |  1
3  |  2   |  2        попадает
4  |  2   |  2        2   |  2
5  |  3   |  3        3   |  3

Из пример №2
T1:                  T2:
ID | FID1 | FID2     FID1 | FID2
1  |  1   |  1        попадает
2  |  1   |  1        попадает
3  |  1   |  1        1   |  1
4  |  2   |  2        попадает
5  |  2   |  2        попадает
6  |  2   |  2        2   |  2

select tt1.id, tt1.fid1, tt1.fid2
  from
    (select id, fid1, fid2, count(*) over (partition by fid1, fid2) c,
     row_number() over (partition by fid1, fid2 order by id) r) tt1
   join
   (select fid1, fid2, count(*) c from t2 group by fid1, fid2) tt2
    on tt1.fid1=tt2.fid1 and tt1.fid2=tt2.fid2
  where tt1.r <= tt1.c-tt2.c