MySQL Forums
Forum List  »  Newbie

Selecting from two tables
Posted by: Amofa Kodom Baffoe
Date: March 28, 2006 03:19AM

I have three tables as follows:

table name: finalexam
fields: studentid, module, marks

table name: contassessment
fields: studentid, module, assesstype, marks

there is a one-to-many relationship between finalexam and contassessment- One final exam module can have more than one assessment. The primary key in contassessment is (studentid, module, aseesstype).

Any select statement to select studentid, finalexam marks and continuos assessment marks summed up for each module?

Options: ReplyQuote

Written By
Selecting from two tables
March 28, 2006 03:19AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.