SELECT * FROM (
SELECT 1 AS ID,'A,B,C,D' AS B UNION ALL
SELECT 2 AS ID,'D,E' AS B
) A
CROSS APPLY(SELECT 1 AS ID,'F,G' AS B UNION ALL
SELECT 1 AS ID,'H,J' AS B UNION ALL
SELECT 2 AS ID,'H,J' AS B
) B
WHERE A.ID=B.ID
ID | B | ID | B |
1 | A,B,C,D | 1 | F,G |
1 | A,B,C,D | 1 | H,J |
2 | D,E | 2 | H,J |
通过分析执行结果可知:CROSS APPLY与INNER JOIN 功能类似