srinivas P

srinivas P

  • NA
  • 168
  • 189.2k

How to add child table rows as columns to the parent table?

Aug 2 2011 12:53 AM
Hi to all ,
 I have a critical doubt for me,
Actually i have two tables 

1)Table1  ---it containes one Record(in this 'Id' is the Reference)
1)Table2 ---it contains more than one or one Records(in this Id is the reference key)


My Requirement is i want to add particular Id details of Table2 To table 1 .

here i have to add Table2 Records to table1 as a single row continues of table1 row.

EX:
ID  Table1 row   table2 Row table2 row  table2 row(if table2 contains more than one Record) like this way.

Is it possible?

I am child in sqlserver.plz help me

Thanks inadvance

Answers (4)