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