By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,294 Members | 2,484 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,294 IT Pros & Developers. It's quick & easy.

copying related rows from one table to another in one row

P: 2
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,...
Sep 18 '07 #1
Share this Question
Share on Google+
2 Replies

P: 47
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.
Sep 18 '07 #2

Expert Mod 10K+
P: 14,534
You will find the article on Database Normalisation here.
Sep 18 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.