I am trying to insert data from one column in one database into a column in another db.
the tables already have the column in place. they both have a unique identifier column (userid) I wrote a little insert statement, but when I try it I get the following error
Msg 512, Level 16, State 1, Procedure trClient_IOIns, Line 20
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
The statement has been terminated.
Insert into DB1.dbo.Client (Notes)
Select DB2.dbo.AllNotes.notes
From DB2.dbo.AllNotes inner join
DB1.dbo.Client on Cid=UserID
there are no duplicate userids
thanks