一个sql问题,针对mdb数据库,谢谢!

[zzc205]

SELECT a.assets_code, b.assets_name, c.depart_name FROM repair_item_assets AS a
LEFT OUTER JOIN assets_detail AS b ON a.assets_code = b.assets_code
LEFT OUTER JOIN department_code AS c ON b.tail_code = c.depart_code

该语句在SQLSERVER中正常,在Access中不通过.
求在mdb库中能实现上述语句功能的sql,即对没有关联上的记录予以保留,只是相应字段显示为空

[Rotaxe]

加上()试试
SELECT a.assets_code, b.assets_name, c.depart_name FROM (repair_item_assets AS a
LEFT OUTER JOIN assets_detail AS b ON a.assets_code = b.assets_code )
LEFT OUTER JOIN department_code AS c ON b.tail_code = c.depart_code

[zzc205]

to Rotaxe: thank you very much!