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.