Help converting TSql to MS Access SQL

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Other Forums

MS Access

Help converting TSql to MS Access SQL

Author

Topic

mchase
Starting Member

1 Post

Posted - 2008-10-01 : 14:08:49

I am trying to convert the below query to MS Access from TSQL, but it errors out. How do I convert this query to MS Access.

UPDATE OrderDetails
SET ShipID = LatestShipping
from OrderDetails
INNER JOIN Orders on Orders.OrderID = OrderDetails.OrderID
INNER JOIN (Select shipping.EEID ,MAX(Shipping.ShipID) AS LatestShipping
FROM Shipping GROUP BY EEID ) sub
ON Sub.EEID= Orders.EEID
Where OrderDetails.ShipID is null AND OrderDetails.Tracking is null AND OrderDetails.ShipDate is null

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2008-10-03 : 02:09:15

Try

UPDATE od
from OrderDetails as od
INNER JOIN Orders on Orders.OrderID = OrderDetails.OrderID
INNER JOIN (Select shipping.EEID ,MAX(Shipping.ShipID) AS LatestShipping
FROM Shipping GROUP BY EEID ) sub
ON Sub.EEID= Orders.EEID
SET ShipID = LatestShipping
Where OrderDetails.ShipID is null AND OrderDetails.Tracking is null AND OrderDetails.ShipDate is null

Madhivanan

Failing to plan is Planning to fail

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources