求助SQL问题

有两张表 T1 和 T2 ，其关联字段是Fid。 请问如何查出这两个表中互不包含的记录？

如果表 T1 中有 F1 , F2 , F3 三个字段。那么如何查出字段 F1 的重复记录？共多少个？

谢谢大家了。

---

SQL code:
1
SELECT * from T1 T WHERE NOT EXISTS(SELECT 1 from T2 WHERE FID=T.FID)
SELECT * from T2 T WHERE NOT EXISTS(SELECT 1 from T1 WHERE FID=T.FID)
2
SELECT F1,COUNT(*)NUM from T1 GROUP BY F1 HAVING COUNT(*)>=2

---

select *
from t1 t
where not exists(select 1 from t2 where fid = t.fid)

select *
from t2 t
where not exists(select 1 from t1 where fid = t.fid)

select f1,count(1)
from t1
group by f1
having count(1) >1

---

select *
from t1,t2
where not exists(select 1 from t2 where fid = t.fid)