SQL Update

[Linda224]

Hello
I am trying to update a table like this:

Update tbl1
set tbl1.col1 = tbl2.col1
where tbl1.col2 = tbl2col2

But of course it doesnt work

Please help!!!!
thank you
Linda

 

[RiverGuy]

You need a from clause

Update tbl1
set tbl1.col1 = tbl2.col1
FROM tbl1, tbl2
where tbl1.col2 = tbl2col2

 

[Linda224]

Ooops I knew I was forgetting something
Thank you Thank you Thank you