 <p>Yes, you need the group by clause, and you need to use the <a href="http://dev.mysql.com/doc/refman/5.6/en/group-by-functions.html#function_group-concat" rel="nofollow">GROUP_CONCAT</a> function. You should group your results by People.fk_rooms and Thing.fk_rooms.</p> <p>Maybe you could use two different queries: The first will result the join of Rooms and People, grouped by fk_rooms, having selected three columns, they are being RoomsID, RoomName, People, while the second will result the join of Rooms and Thing, grouped by fk_rooms, having selected three columns, they are being RoomID, RoomName, Things. In your query you name these selections as t1 and t2 and join t1 and t2 by RoomsID, select t1.RoomName, t1.People, t2.Things.</p> <p>Good luck.</p>