Update query in SQL 2005 - Item not bound

[load3d]

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

 

[RiverGuy]

Literal strings need to be wrapped in single quotes, not double quotes.

 

[load3d]

Thanks for the prompt response. I'm still getting an error though "Item could not be bound dbo.qry_TrucksCheckedIn.Company"

 

[load3d]

Okay, I got it. Thanks again River Guy you probably saved me a few failed test jobs.


UPDATE dbo.tbl_InboundShipments
SET dbo.tbl_inboundshipments.[Status] = 'InYard'
FROM dbo.tbl_inboundshipments, dbo.qry_TrucksCheckedInFF
WHERE dbo.qry_TrucksCheckedInFF.[Company] = dbo.tbl_inboundshipments.CSINBOUND


GO