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

Question

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

Suthish Nair · Answer

Then you need to look into Common Table Expression (CTE)

srinivas P · Answer

I have two tables Example: class table ClassId Cassname 1 10th class student table classid stuName Address 1 xyz hyd 1 abc hyd 1 pqr hyd Now my requirement is i want to show data following way classid stName1 Address1 stuName2 address2 stuname3 address3 1 xyz hyd abc hyd pqr hyd I want to do this in Backendis it possible? Any idea for same application to do in frontend.

Sam Hobbs · Answer

Based on the information you have provided there is nothing special for solving the problem; it is just a matter of readiing the data in and writing it out. If you could explain more about what you need then perhaps someone could provide more of an answer.

Dan Sullivan · Answer

What I think you're referring to describes views which you can read about here http://msdn.microsoft.com/en-us/library/aa214068(v=sql.80).aspx ~ Dan