I am having the following error when I try to access a remote DB on remote server from my MS SQL 2005 Studio Express
Anyone can explain why I have the following error
------------------------------------------------------------------------------------------------------
TITLE: Microsoft SQL Server Management Studio Express
------------------------------
Failed to retrieve data for this request....
sailor152
Last Activity: May 26 '08, 04:38 PM
Joined: Mar 10 '08
Location:
-
Table A have the ids stored.. I want to add the emails to those ids when it matches the table B ids... -
Having this error
--------------------------------------------------------------------------------
Error
SQL query: Documentation
UPDATE B SET email = ( SELECT email
FROM A
WHERE A.Cust_id = B.ID )
MySQL said: Documentation
#1242 - Subquery returns more than 1 row
---------------------------------------------------------------------------------...Leave a comment:
-
Update field with identically named field from another table
I am having two tables, table A has the following fields:
cust_ID, email
Table B has the following fields:
ID, email, name
I want to move email from Table A to B when the cust_ID = ID.
Please notice that both tables are filled with the same ids..
Anyone can help with my sql statment for this
No activity results to display
Leave a comment: