Concatenate multiple MySQL rows into one field query: SELECT a.field1, a.field2, a.field3, ... , ( SELECT GROUP_CONCAT( CONCAT_WS( ' : ', b.field1, b.field2, ... ) SEPARATOR ' # ' ) FROM `tableB` AS `b` WHERE `b`.`field` = `a`.`field` ) AS `concat_example` FROM `tableA` AS `a` WHERE .... (...)