update query?

[CHUMPY]

I have two tables a and b both conating fields x and y,
I wish to update table a field x with the value of table b field x where a.y=b.y;

update a set a.x=b.x where a.y=b.y

but this doesn't seem to work am I am missing something?

thanks Gareth

 

[heydyrtt]

I think the correct syntax would be
UPDATE tablename
set columnname = ??=??
where ??=??

 

[gunjan14]

Hi Gareth,

The syntax is
update a
set a.x = (select b.x
from b
where b.y = a.y)

Thanks and Regards
Gunjan