sql query

Apr 6 2011 8:09 AM

   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. 
 


Answers (2)