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