Selecting from two tables

[Amofa Kodom Baffoe]

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?