Complex Query

[Jack Wayne]

Hi,

I would like to write a query to select the values in one table and concatenate the results from a sub query, could someone point me in the right direction

table1
------
id
name

table2
------
id FK
title

table1
-------
1 Jack
2 John
3 Jayne
4 Juniper
5 jeff

table 2
-------
1 a
1 b
1 c
1 d
2 a
2 b
2 c

Results
----------
1, 'Jack', 1|a,1|b,1|c,1|d
2, 'John', '2|a,2|b,2|c'
3, 'Jayne', ''
4, 'Juniper', ''
5, 'Jeff', ''

Thanks
Jack