Records In a Single Table

[Shalini Bhalla]

I have two tables emp_master and relations_detai ls having Ins_no as a common field ............... ....

emp_master contain all info related to employee and relation_detail s contain details of all family members of employee .....

emp_master 

Ins_no      Name 
123           xyz



relation_detail 

Ins_no   name relation
123        xy   brother
123        xz   brother
123        yz   sister
123        ab   mother

For some reason i have to make a single table for both

emp_master 

Ins_no      Name       relation1      name    relation2  name 
123           xyz          brother          xy         brother   xy

The Problem is that i have already tablew entered in 2 tables and now i want all entries as single , how can i do that ?

[NeoPa]

Are you asking how to show all entries for Ins_No=123 in a single line of output?

[Shalini Bhalla]

Yes , i want all family members in a sigle row , irrespective of no of brothers or sisters ............... .......not in out put but in a new table or in a query

[missinglinq]

And how many "child" fields do you plan on having? Four? Six? A dozen? You're talking about adding fields in a combined table when you should be adding records in your relation_detail table. In other words, you're talking about going from doing this correctly, which is how you currently have it set up, to doing it incorrectly!

For some reason I have to make a single table for both

What is the reason that makes you feel that you have to have a single table?

Linq ;0)>

[NeoPa]

What would be the design of your output data, whether in Query or Table?

This needs consideration. As you may have worked out from Linq's post, almost anything you say here will be wrong, as this request makes little logical sense. Try to answer this anyway as it may help you realise what we're talking about.