34,593
社区成员
发帖
与我相关
我的任务
分享
create table A(X INT,Y INT,Z INT)
INSERT A
SELECT 3,3,22 UNION ALL
SELECT 1,4,33 UNION ALL
SELECT 4,25,6
create table B(X INT,Y INT,Z INT)
INSERT B
SELECT 3,3,2 UNION ALL
SELECT 1,4,3 UNION ALL
SELECT 4,5,6
SELECT A.* FROM A,B WHERE A.X=B.X AND A.Y=B.Y
--结果
X Y Z
3 3 22
1 4 33
select
*
from
a t
where
exists(select 1 from b where x=t.x and y=t.y)
select * from ta a where exists(select 1 from tb where x=a.x and y=a.y)
select * from a t where exists(select 1 from b where x=t.x and y=t.y)
select * from A where exists(select 1 from B where X=A.X AND Y=A.Y)
select * from A ,B where A.X=B.X And A.Y=B.Y
SELECT A.* FROM A JOIN B ON A.X=B.X AND A.Y=B.Y