copying related rows from one table to another in one row

[farajkhah]

i have two table
table1 ( father , mother)
table 2 ( child1:name,age , child2:name, age)
i want to have one table like this
row1: father1,mother1 ,child1 name, child1 age,child2 name,child2 age,...
row2: father2,mother2 ,child1 name, child1 age,child2 name,child2 age,...

[JKing]

Hi there,

I'm not exactly sure what you're trying to accomplish with this but I suggest having a look at this article on normalization. Database Normalization

It is much easier to manipulate your data when the tables are normalized.