Message-ID: <08c801c314f0$9a4e11a0$6400a8c0@netadmin> From: "WayneG" <WayneG@uplogon.com> Subject: [Emerald] SQL Help Date: Wed, 7 May 2003 18:30:06 -0500
How can I make this work?
UPDATE SubAccounts
SET SubAccounts.PhoneHome=MasterAccounts.PhoneHome
WHERE (SubAccounts.CustomerID=6096)
Server: Msg 107, Level 16, State 3, Line 1
The column prefix 'MasterAccounts' does not match with a table name or alias
name used in the query.
Thank you,
-Wayne