469,322 Members | 1,130 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,322 developers. It's quick & easy.

SELECT query on joined tables

Here are two sample tables of information which are used by a high school to keep track of the grades for its students. One table contains the names and addresses of the students, together with a student ID number. The second table contains the class name and class ID number, together with the student ID number and the grade for that student for that class. If the student did not take the class, the class grade is left empty. To list the grades for all the courses taken by a student, you have to use Table 1 to get the name of the student and the Student ID, and then use the Student ID to look in Table 2 to find the classes for which this student has a grade.


Two Sample Tables of Information


1. Student Table
Student ID
Student Name
Student Address Line 1
Student Address Line 2
Student Zip Code

2. Class Table
Class ID
Class Name
Student ID
Class Grade
Semester (Fall, Spring)
Teacher
Year


List the students by name and their grades for all classes taken in the Fall semester of last year.


Which lines of the tables are needed to get the information for the business report?


Thank you
DB
May 7 '07 #1
1 887
MMcCarthy
14,534 Expert Mod 8TB
You have posted this in the Articles Section. I am moving it to the Oracles forum.

ADMIN
May 7 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by allyn44 | last post: by
1 post views Thread by Carl B Davis | last post: by
14 posts views Thread by Tom | last post: by
2 posts views Thread by Fendi Baba | last post: by
1 post views Thread by racquetballer | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
reply views Thread by listenups61195 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.