SQLite Forum

Update with group_concat
Login
I have the following group_concat SQLite query :

SELECT
      GROUP_CONCAT(Plaasno) 
FROM
    wingrd13
group by Aliasnaam


This works perfectly,but if I use it as a sub-query with update, it update all the rows based on the group_concat of the first Aliasnaam.

The update query is as follows :


Update wingrd13 
set Plaasnommers=(SELECT
      GROUP_CONCAT(Plaasno) 
FROM
    wingrd13
group by Aliasnaam)


What am I missing? 

Regards