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

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: LEFT or RIGHT JOIN - can't see where I'm going wrong?
Дата
Msg-id CAKFQuwYDLhjP9PL5Cg2HGd5jymrAm+tEfX29=0qO4kEJUT8wDA@mail.gmail.com
обсуждение исходный текст
Ответ на LEFT or RIGHT JOIN - can't see where I'm going wrong?  (Pól Ua Laoínecháin <linehanp@tcd.ie>)
Список pgsql-novice
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: Pól Ua Laoínecháin
Дата:
Сообщение: LEFT or RIGHT JOIN - can't see where I'm going wrong?
Следующее
От: Santosh Udupi
Дата:
Сообщение: Not able to restore generated columns due to a function