http://blog.csdn.net/xdfwsl/article/details/1485404
关于Access的左连接SQL写法(Access有点变态,写法还真摸索不出来,支持多个 )
一个左连接:select a.* from Table1 a left join Table1 b on (a.no=b.no)
二个左连接:select a.* from (Table1 a left join Table1 b on a.no=b.no) left join Table1 c on (b.no=c.no)
三个左连接
A1、A2、A3、A4、A5四个表都有编号字段:
SELECT A1.编号
FROM (((A1 LEFT JOIN A2 ON A1.编号 = A2.编号) LEFT JOIN A3 ON A2.编号 = A3.编号) LEFT JOIN A4 ON A3.编号 = A4.编号) LEFT JOIN A5 ON A4.编号 = A5.编号