Psql: combining related tables for update?

Hi,
Is there a way in psql to update value of columns from two related tables in just one prepared query statement?
For example:
Table 1(t1) has user_name and Table 2(t2) has street_name, which is connected by t1.id = t2.user_id .

I just found the solution for sql and not for psql. The solution in sql does not work in psql.

I really appreciate your help.

Best,

That’s b/c all flavors of SQL are not the same–what works in SQLite, or Oracle, etc. might not work in PostgreSQL.

Do you have a link to the particular lesson that this refers to?
Did you take a look at the documentation?

1 Like