Mysql query question

[eluser]Krzemo[/eluser]
This should work - if not digg around group_concat mysql function

Code:

SELECT p.personID
, p.name
, GROUP_CONCAT(j.jobID) AS jobID
, GROUP_CONCAT(j.jobtitle) AS jobtitle
FROM people p
JOIN jobs j ON j.personID = p.personID
GROUP BY p.personID
, p.name