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