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
3 Barnes Mary 74 32
4 Margy 74 2
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
3 Barnes Mary 74 32
4 Barnes Margy 74 2
etc.
Thanks very much,
Steve