如何判断两张表之间的包含记录有多少条？
有表A和表B两张表
如何判断表A中包含表B中多少重复的字段数据
最后结果只要一个数字
[解决办法]
select count(1)
from (select a,b,c from tb1 intersect select a,b,c from tb2) as T
[解决办法]
Select Count(1) As 结果
From A
Where Exists(Select 1 from B Where B.关键字=A.关键字)
select COUNT(*) from A
inner join B on A.字段A1=B.字段B1 and A.字段A2=B.字段B2 and 其他对应字段
select count(1)
from (
select id
from A
intersect
select id
from B
) as t
