I am getting crazy to update in BASE a table column with the values of another table of the same database ( hsqldb).
The most “standard” way in SQL is using a JOIN:
UPDATE “table1” set “table1”.“column1” = “table2”.“column1”
JOIN “table2” ON “table2”.“id” = “table1”.“id”
where […];
Unfortunately this statement does not work. An error regarding the not retreived “table2”.“column1” is issued. I double checked for syntax issues. A SELECT statement with the same join works like a charm.
Is there any other way?
Thanks, (Linux, LO 6.3.x, hsqldb)
P.S. I need to use the double quotes to reference the tables/columns.