'access好像每个 left join 要加 () SELECT * FROM ((DIANBIAO LEFT JOIN XIAOQU ON val(dianbiao.校区编号)=xiaoqu.编号) (LEFT JOIN louhao ON val(dianbiao.楼房编号)=louhao.编号)) ORDER BY 表号
SELECT * FROM ((DIANBIAO LEFT JOIN XIAOQU ON val(dianbiao.校区编号)=xiaoqu.编号) LEFT JOIN louhao ON val(dianbiao.楼房编号)=louhao.编号) ORDER BY 表号
听楼主说起来似乎有点摸不透,没发现什么问题,仔细检查一下吧. 第一个SQL要改改,access不支持这样写 select * from ( SELECT * FROM DIANBIAO LEFT JOIN XIAOQU ON val(dianbiao.校区编号)=xiaoqu.编号) as AA LEFT JOIN louhao ON val(AA.楼房编号)=louhao.编号 ORDER BY 表号
select * from ( SELECT * FROM DIANBIAO LEFT JOIN XIAOQU ON val(dianbiao.校区编号)=xiaoqu.编号) as AA LEFT JOIN louhao ON val(AA.楼房编号)=louhao.编号 ORDER BY 表号顶这个
SELECT *
FROM
((DIANBIAO LEFT JOIN XIAOQU ON val(dianbiao.校区编号)=xiaoqu.编号)
(LEFT JOIN louhao ON val(dianbiao.楼房编号)=louhao.编号))
ORDER BY 表号
FROM
((DIANBIAO LEFT JOIN XIAOQU ON val(dianbiao.校区编号)=xiaoqu.编号)
LEFT JOIN louhao ON val(dianbiao.楼房编号)=louhao.编号)
ORDER BY 表号
第一个SQL要改改,access不支持这样写
select * from (
SELECT *
FROM
DIANBIAO LEFT JOIN XIAOQU ON val(dianbiao.校区编号)=xiaoqu.编号) as AA
LEFT JOIN louhao ON val(AA.楼房编号)=louhao.编号
ORDER BY 表号
SELECT *
FROM
DIANBIAO LEFT JOIN XIAOQU ON val(dianbiao.校区编号)=xiaoqu.编号) as AA
LEFT JOIN louhao ON val(AA.楼房编号)=louhao.编号
ORDER BY 表号顶这个