Update works in ACCESS, but not SQL2000

[Andy Ousterhout]

The following works great in ACCESS, but not in SQL.  What am I missing?

    UPDATE   tabItems
    INNER     JOIN tabInvoicedItems ON [tabItems].[ID]=[tabInvoicedItems].[ID]
    SET        tabInvoicedItems.Item_FK = [item_PK];

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

---