SitePoint Sponsor

User Tag List

Results 1 to 2 of 2

Thread: SQLQuery Help

  1. #1
    SitePoint Member
    Join Date
    Dec 2009
    Posts
    1
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Question 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)

  2. #2
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,274
    Mentioned
    60 Post(s)
    Tagged
    3 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
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •