bostonroxx
asked on
SIMPLE UPDATE INNER JOIN PROBLEM FIX
Hello can anyone tell me the syntax I should use to complete this Update Statement
Update tblOrderDriversExtraCharge s
INNER JOIN tblOrderDrivers ON tblOrderDrivers.OrderDrive rID = tblOrderDriversExtraCharge s.OrderDri verID Set AccessorialChargeAmount = 0, Drivercompensation = 0 WHERE tblOrderDrivers.OrderNumbe r='87521'
The Inner Join does not work in SQL Server. Thanks
Update tblOrderDriversExtraCharge
INNER JOIN tblOrderDrivers ON tblOrderDrivers.OrderDrive
The Inner Join does not work in SQL Server. Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER