SELECT
p. NAME,
p.office,
p.manager,
GROUP_CONCAT( c.ListPrice),
p.managerName,
p.assignedTime,
p.assignedName
FROM
own_project p
p. NAME,
p.office,
p.manager,
GROUP_CONCAT( c.ListPrice),
p.managerName,
p.assignedTime,
p.assignedName
FROM
own_project p
LEFT JOIN own_contract c ON p.pId = c.projectId GROUP BY p.PId