How to run the following Update query correctly

[chrislynch8]

Hi,

I want to update two fields in a table but I want to set the values using select statements?

UPDATE table SET column1=(SELECT a from x where b =table.id), column2=(SELECT z from x where b =table.id)

Is this possible?

[chrislynch8]

Have this sorted.

I need to use Where Exists at the end of the statement