"Newbie" <noidea@nospam.com> wrote in message
news:elVEc2U%23EHA.2016@TK2MSFTNGP15.phx.gbl...
> Hi
> I am trying to write an update query that update the BG1 field in the
> Customer table with the BG value in the Agreements Table from a different
> database.
>
> Here is what I have so far . . . but it doesn't work - I get the error
>
> Server: Msg 8152, Level 16, State 2, Line 1
> String or binary data would be truncated.
> The statement has been terminated.
>
> UPDATE tblCustomer SET BG1 = A.BG From tblCustomer C, MIS.dbo.Agreements A
> WHERE C.Customer = A.Customer
>
> What am I doing wrong?
>