RE: Update works in ACCESS, but not SQL2000

[Robertson-Ravo, Neil (RX)]

you need to rewrite the SQL to be T-SQL Compliant.

   _____  

From: Andy Ousterhout [mailto:[EMAIL PROTECTED]
Sent: 13 May 2004 00:24
To: SQL
Subject: Update works in ACCESS, but not SQL2000

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]

---