Results 1 to 2 of 2

Thread: SQL Select

  1. #1
    Join Date
    Oct 2003
    Location
    Piperdam, Dundee, Scotland
    Posts
    2

    Unanswered: SQL Select

    Hi
    I have four tables Students, Tutors, Results, Modules

    I am trying to get the following information in SQL format:

    Display all the Modules that the tutors teach and display the AVg, Min, Max results even where there are Nulls in the Tutor Teaches field.

    I start by using the Select Count and I know that I have to use a join to get the information from Tutors but I'm not sure how to apply the join?

    HELP!

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322

    Re: SQL Select

    Originally posted by 986100911
    Hi
    I have four tables Students, Tutors, Results, Modules

    I am trying to get the following information in SQL format:

    Display all the Modules that the tutors teach and display the AVg, Min, Max results even where there are Nulls in the Tutor Teaches field.

    I start by using the Select Count and I know that I have to use a join to get the information from Tutors but I'm not sure how to apply the join?

    HELP!
    Engaging telepathy engines......

    damn thing is broke at this time...

    Can you post some DDL, Sample data and maybe any shot you took at DML?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

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