34,575
社区成员
发帖
与我相关
我的任务
分享
SELECT * FROM T1 CROSS APPLY (SELECT T2.* FROM T1,T2 WHERE T1.ID=T2.ID AND T1.NAME=T2.NAME) M
SELECT * FROM T1 CROSS APPLY T2 WHERE T1.ID=T2.ID AND T1.NAME=T2.NAME
SELECT * FROM T1 JOIN T2 ON T1.ID=T2.ID AND T1.NAME=T2.NAME
SELECT * FROM T1 CROSS APPLY (SELECT * FROM T2 WHERE T1.ID=T2.ID AND T1.NAME=T2.NAME) M
为什么第一个 查询和 第四条查询语句结果不一样,而2 3 4的结果是一样的。他们的执行顺序是怎么样的
SELECt * from t1
select * from t2