I am currently using QGIS and it's database tool with custom plugins. I have to update a specific Table using an SQL query but I cannot use Database specific programs like PostGIS. Here is the test query I used:
UPDATE "BAL" SET "BAL"."BAL_ADRESSE" = "BAL2"."bal_adresse" FROM "BAL", "BAL2" WHERE "BAL"."BAL_ADRESSE" != "BAL2"."bal_adresse";
It is quite a simple query, I am trying to replace values in the first BAL table using a csv I created myself and imported in the same database afterwards, calling it BAL2. Yet everytime I try to do anything than basic selections, like the update I need to do, it returns an error message and never the same.
So here are my questions: Is my query wrong? And is QGIS unable to use the UPDATE query?