Question

SQL查询消除在另一个表里存在的记录，如何写呀？

Answer 1

select
T1.AId,T2.BId
from
T1
inner
join
T2
on
T1.AId
=
T2.BId
在后面加个where
条件判断，where
T1.AId
not
in(select
AId
from
T3)
and
T2.BId
not
in(select
BId
from
T3
)
两个表连接也要有相同的字段啊。