Join one row to multiple rows in another table
Use: SELECT x.name, GROUP_CONCAT(y.property SEPARATOR ‘, ‘) FROM PEOPLE x LEFT JOIN PROPERTIES y ON y.name = x.name WHERE x.age > 26 GROUP BY x.name You want the MySQL function GROUP_CONCAT (documentation) in order to return a comma separated list of the PROPERTIES.property value. I used a LEFT JOIN rather than a JOIN in order …