I'm trying to create a scheduled job to update the "Status" Column in my tbl_InboundShipments to "In Yard" where the Inbound# matches the Company# in a query that shows trucks that are checked in. What am I doing wrong?
UPDATE dbo.tbl_InboundShipments
SET dbo.tbl_inboundshipments.Status = "InYard"
WHERE dbo.qry_TrucksCheckedIn.Company = dbo.tbl_inboundshipments.CSinbound
GO
UPDATE dbo.tbl_InboundShipments
SET dbo.tbl_inboundshipments.Status = "InYard"
WHERE dbo.qry_TrucksCheckedIn.Company = dbo.tbl_inboundshipments.CSinbound
GO