I want to define a SQL statement to end up with a two column table:

employee, jobs
==============
john, joba:jobb:jobc
doug, jobd:jobe
bill, jobt:joby:jobz

where I have a 1-many table:

employee, job
=============
john, joba
doug, jobd
john, jobc
bill, joby
bill, jobz
john, jobb
doug, jobe
bill, jobt

Any help is greatly appreciated.