Correlated update 1

[hallux]

Hello,
Looking for help structuring the subquery in a correlated update.

UPDATE rainfall SET system = 'METRIC'
WHERE
(SELECT * FROM rainfall, location
WHERE rainfall.city_id = location.city_id AND location.country = 'CANADA')

-Hallux

 

[carp]

I think what you want is:

UPDATE rainfall SET system = 'METRIC'
WHERE city_id IN
(SELECT city_id FROM location WHERE country = 'CANADA');

 

[hallux]

That is eactly what I needed.
Thank you.
-Hallux