Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
5
Reply
Fetch Records from two table in a single row
Bikash Das
Aug 13 2012 9:24 AM
1.1k
Reply
suppose i have two table like
Student
------------------------
Roll
Name
Address
1
Bikash
bbsr
2
Tapan
ctc
3
Saroj
puri
4
Manoj
bbsr
Book Issue
-------------------------------------
Roll
Book
Date
1
C#
21/03/2012
2
C programming
21/03/2012
1
Sql Server
03/04/2012
2
C++
03/04/2012
Result should be
---------------------------------
Roll Name Book Date
--------------------------------------------------------------------------------------------------------
1 Bikash C#,Sql Server 21/03/2012,03/04/2012
2 Tapan c programming,c++ 21/03/2012,03/04/2012
please give me solution. already i have used group by with role number but not working.
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
5
)
Next Recommended Forum
MS SQL 2008, Load balancing and database mirroring or failover clustering?
Query for Calculating Third Column and returning these values using two columns