SQL Question

From: W. Scott Moore <sirws_at_hotmail.com>
Date: Wed, 1 Dec 1999 10:38:16 -0700
Message-ID: <h_c14.516$Rk2.16787@news.uswest.net>

I am trying to run an update:

UPDATE SDE.CH_ADDRESS A, SDE.ADDRESS_PNT_at_MSGISPROD B SET A.LOT_NUM = B.LOT_NUM,
A.PARCEL = B.PARCEL
WHERE A.LOT_NUM = 0 AND A.FULL_ADDRESS = B.FULL_ADDRESS but it doesn't seem to like the use of multiple update tables. I *believe* that I used this syntax in MS SQL 6.5... I think I must be a little rusty.

Any help would be greatly appreciated.

Sincerely,
W. Scott Moore
City of Chandler, AZ Received on Wed Dec 01 1999 - 11:38:16 CST