-
SQL: 1 to many, with many listed in one column
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|