select *
from A表
where cast(F1 as varchar)+'^'+ cast(F2 as varchar)
not in
(select cast(A.F1 as varchar)+'^'+ cast(A.F2 as varchar)
from A
inner join B on A.F1=B.F1 and A.F2=B.F2
)
from A表
where cast(F1 as varchar)+'^'+ cast(F2 as varchar)
not in
(select cast(A.F1 as varchar)+'^'+ cast(A.F2 as varchar)
from A
inner join B on A.F1=B.F1 and A.F2=B.F2
)
隻要此字符不在F1與F2字段中出現即可。
干吗要加分割符啊?直接
select *
from A表
where cast(F1 as varchar)+ cast(F2 as varchar)
not in
(select cast(A.F1 as varchar+ cast(A.F2 as varchar)
from A
inner join B on A.F1=B.F1 and A.F2=B.F2
)
可以嘛?