'GROUP BY in UPDATE FROM clause

I really need do something like that:

UPDATE table t1 
SET column1=t2.column1 
FROM table t2 
INNER JOIN table t3 
USING (column2) 
GROUP BY t1.column2;

But postgres is saying that I have syntax error about GROUP BY clause. What is a different way to do this?

postgresqlgroup-by


Solution 1:[1]

In MariaDB/ MySQL this SQL work :

 UPDATE table t1 left join (
   SELECT t2.column1, column2
   FROM   table t2
   JOIN   table t3 USING (column2)
   GROUP  BY column2
   ) AS sq on t1.column2=sq.column2 
SET column1=sq.column1;

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 INPEC

Related Questions