Re: Selecting from two tables

[Felix Geerinckx]

Amofa Kodom Baffoe wrote:
> I have three tables as follows:

I only see two.

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

SELECT f.studentid, f.module, f.marks, COALESCE(SUM(ca.marks),0)
FROM finalexam f
LEFT JOIN contassessment ca ON ca.studentid = f.studentid AND ca.module = f.module
GROUP BY f.studentid, f.module, f.marks

--
felix
Please use BBCode to format your messages in this forum.