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,