Re: Proper relational database?

On 24 April 2016 at 12:29, Geoff Winkless <pgsqladmin(at)geoff(dot)dj> wrote:
> To find students with no exam today (the other point of your argument):
>
> SELECT student_id, name
> FROM student
> LEFT JOIN exam USING(student_id)
> WHERE exam_date=CURRENT_DATE AND exam.student_id IS NULL;

*sigh* problem with writing emails in a rush. Of course I meant

SELECT student.student_id, name
FROM student
LEFT JOIN exam ON exam.student_id=student.student_id AND exam_date=CURRENT_DATE
WHERE exam.student_id IS NULL;

Geoff