| SitePoint Sponsor |
|
|
User Tag List
Results 1 to 2 of 2
Thread: SQLQuery Help
-
Dec 9, 2009, 18:35 #1SitePoint Member
- Join Date
- Dec 2009
- Posts
- 1
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
SQLQuery Help
How to Create a query which shows which teachers have accompanied which tours, which schools the teachers teach at, what the teachers’ roles are on the tour and whether or not the teachers have any additional skills?
Teacher(Teacher_Id, Name, E-mail, Contact, FirstAid_Q, Extra_skills, Pass_Conf, School_Id)
TeacherTour(Teacher_Id, Tour_Id, Teacher_role)
-
Dec 9, 2009, 20:52 #2SQL Consultant
- Join Date
- Jul 2002
- Location
- Toronto, Canada
- Posts
- 38,809
- Mentioned
- 49 Post(s)
- Tagged
- 1 Thread(s)
sorry, we don't do homework assignments here
we would be glad to help you, but ~you~ have to do all the work
why don't you try it and see what you get? we'll help if you're having trouble
Bookmarks