working with GROUP_CONCAT error
So I've been practicing with random queries and I've run into a problem
First off, here is my query:
and that works perfectly for what I need (I need the items in a list, like the group_concat function gives me), except when there are no records for that user in the items table. I'm wondering if you can help me write a query that would work both ways? So it would return the list of users from the a table, no matter if they have items or not.
GROUP_CONCAT(items.id) AS itemslist,
FROM a LEFT JOIN items ON items.owner = a.username
GROUP BY a.username