i have 3 tables
1st table named registration contains following fields,
regid,studname,regno,classid,dob,sex,parent,houseno,place1,place2,city,phono,mobno,office,offplace1,offplace2,offcity,offpho,offmob,fax,nationalty,busid
2nd table contains
classid,classname,fees,duration - named class
3rd contains
busid,busno,busname,busroute,totalstrength,driver,asistant-named bus
i want to select regid,studname,regno,classname,dob,sex,parent,houseno,place1,place2,city,phono,mobno,office,offplace1,offplace2,offcity,offpho,offmob,fax,nationalty,busno
from registration,class,bus according to studname.
also select all the above details.
lz help.