Hi I have the following MySql database structure: `items` table: id | itemid | title ---+--------------- 1 | 314 | Black hat 2 | 587 | Golden Pencil `tags` table: id | tag ---+-------- 1 | clothes 2 | pens 3 | presents `items_tags` table: id | item | tag ---+------+---- 1 | 314 | 1 1 | 314 | 3 1 | 587 | 2 1 | 587 | 3 I'm trying to create an sql query to get all items including their tags in one query (I use it in the main for the main page). this is what I tried: SELECT i.* items, t.tag FROM items i JOIN items_tags it ON i.id = it.item JOIN tags t ON it.tag = t.id it gives a row of the item for every tag in database. for example if an item as 5 tags, it will give me 5 rows for that item. I need one row per item with tags as a string, or array or something. maybe an Inner join or a sub query.... I'm new to this but very willing to learn... can you help ?