判断:表1数据 是否存在于 表2 ,存在列出来,不存在结果为空
EXISTS方法:
SELECT A.ID
FROM info A
WHERE EXISTS(SELECT 1 FROM test_b B
WHERE A.id = B.ID)
显示结果:
INNER JOIN方法:
SELECT A.*,B.*
FROM info A
INNER JOIN test_b B
ON A.id = B.ID
显示结果:
用IN
SELECT A.*
FROM info A
WHERE A.id IN(SELECT B.id FROM test_b B)
显示结果: