Reposted for clarity:

Hi,

Can I do the following with a select all type statment"

I have a table that looks something like this:

r# household Parent house# ages
1  Smiths    Robert 27 42
2            Bobby  27  4 && child of Robert
3  Barnes    Mary   74 32
4            Margy  74  2 && child of Mary
etc.

Can I use an SQL statement to generate a new table that looks anthing like this?

r# household inhabitants   house# ages
1  Smiths    Robert, Bobby 27     42,4
2  Barnes    Mary, Margy   74     32,2
etc.

Would it make a difference if the starting out table looked like this?

r# household Parent house# ages
1  Smiths    Robert 27     42
2  Smiths    Bobby  27     4 && child of Robert
3  Barnes    Mary   74     32
4  Barnes    Margy  74     2 && child of Mary
etc.

Thanks very much,
Steve