SQL 2000 Query syntax issues and joins

trying to update a field as shown below but got all my joins wrong in this syntax!!!

UPDATE    tbl_Inventory
SET              tbl_Inventory.Inventory_ManufacturerSN = 'test'
FROM         triscan_licencing.dbo.OdysseyPartsMasterView xx

INNER JOIN
                      tbl_Jobs ON tbl_Inventory.Inventory_ID = tbl_Jobs.Jobs_ParentInventoryID INNER JOIN
                      triscan_orders.dbo.tbl_OrderLines yy ON yy.OrderLines_ID = tbl_Inventory.Inventory_OrderLineId
WHERE     xx.PN = tbl_Inventory.Inventory_PartNumber AND (xx.version IS NOT NULL) AND inventory_ID = 118386 AND yy.Orderlines_Paid = 0
Chris MichalczukConsultantAsked:
Who is Participating?
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.