Hello, I'm new to the forum and need help with PostgreSQL DBMS.
My question is the following, in the following code used in the MySQL DBMS the execution happens perfectly, because in PostgreSQL it shows an error.
MySQL Code:
UPDATE userT
INNER JOIN empresa ON userT.idEmp = empresa.idEmp
SET userT.telefone = '15253485',
empresa.cargaTrab = 12
WHERE idUser = 1;
The code mentioned above performs perfectly in Mysql but in PostgreSQl the following error appears:
ERROR: syntax error at or near "INNER".
Could anyone help me?