Re: [GENERAL] Left join help

On 06/24/2017 08:01 AM, Arup Rakshit wrote: 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

Re: [GENERAL] Left join help

Hello Adrian, The way John taught me this query with CTE and then how that can be using with JOIN really helped me to understand. The query below is from John and it worked. SELECT * FROM missions LEFT JOIN submissions INNER JOIN members ON submissions.member_id = members.id

Re: [GENERAL] Left join help

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.