SQL 2000 Query syntax issues and joins

Posted on 2011-10-14
Last Modified: 2012-05-12
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

                      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
Question by:chrismichalczuk
    1 Comment
    LVL 76

    Accepted Solution


    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    Is it worth it to buy an Echo? In a word, yes! For me it was definitely worth it. I use mine on a daily basis. Prologue & Privacy At first, I was very skeptical about the Amazon Echo. In general, I don't like voice assistants. I don't li…
    This is about my first experience with programming Arduino.
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now