0

I have 2 tables: 2014, 2015

Each table has these columns: id, county

I need to update 2015.county with the same value found in 2014.county for an id that equals '15'

Having a terrible time with the syntax using UPDATE, SET, and WHERE; however I know this should be relatively simple. I don't want to use a JOIN statement.

Thanks in advance from a new user to PostgreSQL

j_2112_ari
  • 33
  • 4
  • Does this answer your question? [How to do an update + join in PostgreSQL?](https://stackoverflow.com/questions/7869592/how-to-do-an-update-join-in-postgresql) – e_i_pi Jul 28 '21 at 22:37

0 Answers0