TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
srinivas P
NA
168
193.5k
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
Reply
Answers (
4
)
Need Help in solving SQL QUERY
How to get next row value