How to insert columns as rows?

Question

Hi, to all

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 insert data following way

classid	stName	Address	stuName	address		stuname		address
1	xyz	hyd	abc	hyd		pqr		hyd

i want to display multiple columns data in single row
please help me



Thanks inadvance