• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 199
  • Last Modified:

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
0
Chris Michalczuk
Asked:
Chris Michalczuk
1 Solution

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now