select d.wname,o.customer,o.OrderTime ,d.quantity ,g.gethering ,g.remain ,f.farestatus ,s.quantity from (((OrderDetail as d left join gethering as g on d.DetailID=g.DetailID) left join fare as f on d.detailid=f.detailid) left join shipment as s on d.detailid=s.detailid) join orders as o on d.OrderID=o.OrderID order by d.wname
你把 join orders as o on d.OrderID=o.OrderID 改成 left join orders as o on d.OrderID=o.OrderID 就可以了。
,d.quantity
,g.gethering
,g.remain
,f.farestatus
,s.quantity
from
(((OrderDetail as d left join gethering as g on d.DetailID=g.DetailID)
left join fare as f on d.detailid=f.detailid)
left join shipment as s on d.detailid=s.detailid)
join orders as o on d.OrderID=o.OrderID
order by d.wname
join orders as o on d.OrderID=o.OrderID
改成
left join orders as o on d.OrderID=o.OrderID
就可以了。
access不支持join连结的默认连接,在sqlserver中join被认为是inner join即内联,而access不行,必须指明连结方式.inner join,left join,right join.