Hello!
There is such a table:
user || user_id || site || date || date_support || modul || test | 1 | site.ru | 14.09 | 13.09 | cms test | 1 | site.net | 15.09 | 12.09 | cms test1 | 11 | site.org | 16.09 | 14.09 | cms test | 1 | site.com | 17.09 | 15.09 | cms test1 | 11 | site.guru| 18.09 | 16.09 | cms test2 | 12 | site.ua | 19.09 | 18.09 | cms test | 1 | site.fr | 14.09 | 19.09 | cms I have such a request:
"SELECT user, user_id, site, MIN(date) AS flag, MAX(date_support) AS flag1 FROM license where modul = 'cms' GROUP BY 1 HAVING COUNT(*) > 1 order by flag" The query finds duplicate values in the modul table and sorts by flag.
How to make me get all the sites from the site table separated by commas? Since now displays only one!
