?
/*?
CREATE?TABLE?A(id?INT,?NAME?VARCHAR(30))?
CREATE?TABLE?B(id?INT,?marks?VARCHAR(30))?
?
INSERT?INTO?A?
SELECT?1,'周杰倫'?union?
SELECT?2,'周星馳'?union?
SELECT?3,'成龍'?union?
SELECT?4,'李連杰'?union?
SELECT?5,'洪金寶'?union?
SELECT?6,null?union?
SELECT?7,null?
?
?
INSERT?INTO?b?
SELECT?1,12?union?
SELECT?3,55?union?
SELECT?5,56?union?
SELECT?6,null?union?
SELECT?11,28?union?
SELECT?16,47?union?
SELECT?25,null?
*/?
?
?
????????????
?
select?*?from?A?CROSS??APPLY?(select??*??from?B?where?a.id=b.id)??c???
?
/*?
?
id????NAME????id????marks?
1????周杰倫????1????12?
3????成龍????3????55?
5????洪金寶????5????56?
6????NULL????6????NULL?
?
*/?
?
?
select?*?from?A?outer?APPLY?(select??*??from?B?where?a.id=b.id)??c?
?
/*?
?
id????NAME????id????marks?
1????周杰倫????1????12?
2????周星馳????NULL????NULL?
3????成龍????3????55?
4????李連杰????NULL????NULL?
5????洪金寶????5????56?
6????NULL????6????NULL?
7????NULL????NULL????NULL?
?
*/?
?
/*?
DROP?TABLE?A?
DROP?TABLE?B?
*/?
?
?
?
?

轉載于:https://www.cnblogs.com/qanholas/archive/2010/10/30/1865035.html

總結

以上是生活随笔為你收集整理的CROSS APPLY 和outer apply的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。