Postgres Pro
Downloads
Home   >   mailing lists

Re: LEFT or RIGHT JOIN - can't see where I'm going wrong? - Mailing list pgsql-novice

From David G. Johnston
Subject Re: LEFT or RIGHT JOIN - can't see where I'm going wrong?
Date
Msg-id CAKFQuwYDLhjP9PL5Cg2HGd5jymrAm+tEfX29=0qO4kEJUT8wDA@mail.gmail.com
Whole thread Raw
In response to LEFT or RIGHT JOIN - can't see where I'm going wrong?  (Pól Ua Laoínecháin <linehanp@tcd.ie>)
List pgsql-novice
Tree view
On Saturday, January 23, 2021, Pól Ua Laoínecháin <linehanp@tcd.ie> wrote:

What I want is a result for quiz 4 with NULL for the student_points
fields but including the student_id and esp. the name - I'll put
COALESCE in for the NULL grade for quiz 4.

Cross join students and quizes so every combination is shown then left join the scores onto that combined relation.

David J. 

pgsql-novice by date:

Previous
From: Pól Ua Laoínecháin
Date:
Subject: LEFT or RIGHT JOIN - can't see where I'm going wrong?
Next
From: Santosh Udupi
Date:
Subject: Not able to restore generated columns due to a function