Re: [GENERAL] Left join help

Поиск
Список
Период
Сортировка
От Arup Rakshit
Тема Re: [GENERAL] Left join help
Дата
Msg-id DCCAA4F7-341C-488B-9F04-986FCEE64BAB@outlook.com
обсуждение исходный текст
Ответ на [GENERAL] Left join help  (Arup Rakshit <aruprakshit1987@outlook.com>)
Ответы Re: [GENERAL] Left join help
Список pgsql-general
Дерево обсуждения
Hi,

Thanks everyone for taking time to explain this. I tried to add a case statement and getting errors. Can you tell me how should I add a column to mark which mission is completed and which is not. My try is not working. Instead of the new CASE expression, the query works as expected.

SELECT missions.*, CASE WHEN submissions.id IS NULL THEN 'incompleted' ELSE 'completed' END AS mission_status
FROM missions
LEFT JOIN submissions
INNER JOIN members
ON submissions.member_id = members.id AND members.id = 1
ON missions.id = submissions.mission_id
WHERE missions.track_id = 7

====

ERROR: missing FROM-clause entry for table "missions"
LINE 1: SELECT missions.*, CASE WHEN submissions.id IS NULL THEN 'in...


On Jun 24, 2017, at 4:53 AM, John W Higgins <wishdev@gmail.com> wrote:

SELECT *
FROM missions
LEFT JOIN submissions
INNER JOIN members 
ON submissions.member_id = members.id AND members.id = 1
ON missions.id = submissions.mission_id
WHERE missions.track_id = 7

В списке pgsql-general по дате отправления: