Thanks that worked.

Thanks let me give that a try on Monday

Thanks but I figure this out. Sorry I will post in the newbie section.

Create table #Sold(

customername nchar(50) null default null,

customeremail nchar(255) null default null,

ordernumber int not null,

orderitem int null...

Thanks Geradin!

I will try it tomorrow and let you know.

Let me rephrase my question. Can we update an existing table by doing a join?

Update #TRCD

Set bal = cd.bibal

from lmrcbap3p.misdbw021_dw.dbo.cb_cd_daily cd, #trcd t

where cd.acct = t.acct

and cd.appl = t.appl

Update...