younis abdeljawwad

younis abdeljawwad

  • NA
  • 73
  • 96.5k

select data from three tables

May 24 2012 8:15 PM
i have three tables..

the first
course,,,,,,,,,,,,have     course_id(PK)  ,course_name ....

the second
class,,,,,,,,,,,,,have       class_id(PK) , course_id(FK) , class# ....

the third 
class time,,,,,,have       time_id(PK) , class_id(FK) , start , end , day ....


i want to select in one statement all of the :

course_name , class# , start , end , day

 

Answers (3)