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,...

[barry07]

Why on earth would you want to do that? And what happens when child3 comes along. Suggest you read the excellent artice on Database Normalistion before you go down this road.

You can generate Reports in the format you suggest if you need to, but that doesn't require that your data (Tables) are structured that way.

[MMcCarthy]

You will find the article on Database Normalisation here.