SQL2005如何实现多表联接(难)?
表A
A1 A2 A3
A A A
B B B
表B
B1 B2 B3
A AB1 AB2
A AB3 AB4
B AB5 AB6
B AB7 AB8
表C
C1 C2 C3
A ABC1 ABC2
A ABC3 ABC4
A ABC5 ABC6
B ABC7 ABC8
B ABC9 ABC10
B ABC11 ABC12
如何实现以下结果
A1 A2 A3 B1 B2 B3 C1 C2 C3
A A A A AB1 AB2 A ABC1 ABC2
A AB3 AB4 A ABC3 ABC4
A ABC5 ABC6
B B B B AB5 AB6 B ABC7 ABC8
B AB7 AB8 B ABC9 ABC10
B ABC11 ABC12
[解决办法]
full join
------解决方案--------------------
或则C表最前面,与B、A LEFT JOIN