1
DECLARE @a table(i int)
2DECLARE @b table(i int)
3
4INSERT INTO @a SELECT 1 UNION ALL SELECT 2
5INSERT INTO @b SELECT 1 UNION ALL SELECT 3
6
7SELECT a.i,b.i FROM @a AS a INNER JOIN @b AS b ON a.i =b.i
8
9SELECT a.i,b.i FROM @a AS a LEFT JOIN @b AS b ON a.i =b.i
10
11SELECT a.i,b.i FROM @a AS a RIGHT JOIN @b AS b ON a.i =b.i
12
13SELECT a.i,b.i FROM @a AS a FULL JOIN @b AS b ON a.i =b.i
DECLARE @a table(i int)2
DECLARE @b table(i int)3
4
INSERT INTO @a SELECT 1 UNION ALL SELECT 25
INSERT INTO @b SELECT 1 UNION ALL SELECT 36
7
SELECT a.i,b.i FROM @a AS a INNER JOIN @b AS b ON a.i =b.i8
9
SELECT a.i,b.i FROM @a AS a LEFT JOIN @b AS b ON a.i =b.i10
11
SELECT a.i,b.i FROM @a AS a RIGHT JOIN @b AS b ON a.i =b.i12
13
SELECT a.i,b.i FROM @a AS a FULL JOIN @b AS b ON a.i =b.i 
浙公网安备 33010602011771号