From: "Ali Resting" <ali@realnet.co.sz> Subject: RE: [Emerald] SQL Help Date: Thu, 8 May 2003 08:47:22 +0200 Message-ID: <KFEGKFIIOBFKKNGIFJEPEEOLCHAA.ali@realnet.co.sz>
Try this it should work.
UPDATE SubAccounts
SET SubAccounts.PhoneHome=MasterAccounts.PhoneHome
WHERE (SubAccounts.CustomerID=MasterAccount.CustomerID) AND
(SubAccounts.CustomerID=6096)
Ali Resting
Real Image Internet
-----Original Message-----
From: emerald-request@iea-software.com
[mailto:emerald-request@iea-software.com]On Behalf Of WayneG
Sent: Thursday, May 08, 2003 1:30 AM
To: emerald@iea-software.com
Subject: [Emerald] SQL Help
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
------------
This is a user supported list. If you require assistance from IEA Software's
Support Engineers, please check out our Support resources at
http://www.iea-software.com/support.
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart