Fetch Records from two table in a single row

Question

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.