Can't get subquery to work on multiple fields

I try to update two fields in a table with values from another table, using a sub query based on a form selection that was just made. I have it working for one field but I can’t get right for more fields. This is what I have:


      UPDATE companies
      SET city_eng =
    ( SELECT city_eng
      FROM cities
      WHERE city_id = #Form.city_id #)

like I said this is working but when I try to update a second field I get an error. This is what I tried:


      UPDATE companies
      SET city_eng =
    ( SELECT city_eng
      FROM cities
      WHERE city_id = #Form.city_id #)
      city_gr = 
      SELECT city_gr
      FROM cities
      WHERE city_id = #Form.city_id #)

But that isn’t working. What is wrong in my query? Thank you in advance.

You’re missing a comma :slight_smile:

:headbang: Thanks Guido

:lol:
Time to go to bed :wink:

:slight_smile: Almost but first a relax :drink: Thanks again for the observation