SQL Question
From: W. Scott Moore <sirws_at_hotmail.com>
Date: 1999/12/01
Message-ID: <h_c14.516$Rk2.16787_at_news.uswest.net>#1/1
Date: 1999/12/01
Message-ID: <h_c14.516$Rk2.16787_at_news.uswest.net>#1/1
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 - 00:00:00 CET