SQLite Forum

Update with group_concat
Login
A correlation.  For example:

```
update wingrd13
   set Plaasnommers = (
                        select group_concat(Plaasno)
                          from wingrd13 as S
                         where S.Aliasnaam == wingrd13.Aliasnaam
                      )
```

assuming, of course, that your "correlation" is the Aliasnaam column.  Adjust the correlated subquery so that the it reflects the correlation you want.