Update Statement With Where Clause To Other Tables

Update Statement With Where Clause To Other Tables

Basically I have an update statement which needs to update two fields of a
table but is dependent on its where clause which references other tables
within the database.
For example.
UPDATE TABLE_ONE
SET VALUE_ONE=1,VALUE_TWO=2
WHERE TABLE_TWO.ID = 1818 AND TABLE_TWO.POSITION = TABLE_THREE.ID AND
TABLE_ONE = TABLE_THREE.VALUE = TABLE_ONE.ID;
I hope this is clear. Any help would be greatly appreciated.