比如我的SQL是这样:
select d.wname,month(o.OrderTime), o.Customer
,d.quantity
,g.gethering
,g.remain
,f.farestatus
,s.quantity
from orders o
,OrderDetail d left join gethering g on d.DetailID=g.DetailID
,orderdetail l left join fare f on l.detailid=f.detailid
,orderdetail i left join shipment s on i.detailid=s.detailid
where d.OrderID=o.OrderID
and l.orderid=o.orderid
and i.orderid=o.orderid
and d.wname=l.wname and l.wname=i.wname
order by d.wname,month(o.ordertime)如果是ACCESS数据库,ADOQuery OPEN时则出现"不支持连接表达式"的错误提示,若改用MS SQL数据库,则正确。
select d.wname,month(o.OrderTime), o.Customer
,d.quantity
,g.gethering
,g.remain
,f.farestatus
,s.quantity
from orders o
,OrderDetail d left join gethering g on d.DetailID=g.DetailID
,orderdetail l left join fare f on l.detailid=f.detailid
,orderdetail i left join shipment s on i.detailid=s.detailid
where d.OrderID=o.OrderID
and l.orderid=o.orderid
and i.orderid=o.orderid
and d.wname=l.wname and l.wname=i.wname
order by d.wname,month(o.ordertime)如果是ACCESS数据库,ADOQuery OPEN时则出现"不支持连接表达式"的错误提示,若改用MS SQL数据库,则正确。
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货