Re: Extend inner join to fetch not yet connected rows also

From: Jan Kohnert <nospam001-lists(at)jan-kohnert(dot)de>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Extend inner join to fetch not yet connected rows also
Date: 2019-09-22 12:08:53
Message-ID: 1780284.qfRisySgFs@kohni-mobil
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hey,

Am Sonntag, 22. September 2019, 13:21:46 CEST schrieb Arup Rakshit:
> I have craftsmanships table which has (id, name) and users table (id, email,
> ..). When a user has some craftsmanships, they are stored inside the
> contractor_skills(user_id, craftsmanship_id, id) table.

[...]

> But I want to list all craftsmanships and has column should have `t` when
> user_id #8 has it, else `f`. How can I extend this query?

maybe something like

select
c.id,
c.name,
case when cs.user_id = 8 then true else false end as has
from craftsmanships c
left join contractor_skills cs
on cs.craftsmanship_id = c.craftmanship_id;

--
MfG Jan

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Arup Rakshit 2019-09-22 12:12:42 Re: Extend inner join to fetch not yet connected rows also
Previous Message Arup Rakshit 2019-09-22 11:21:46 Extend inner join to fetch not yet connected rows also