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

SELECT
        craftsmanships.id,
        craftsmanships.name,
        CASE WHEN contractor_skills.user_id IS NULL THEN
                FALSE
        ELSE
                TRUE
        END AS has
FROM
        "craftsmanships"
        LEFT JOIN "contractor_skills" ON "contractor_skills"."craftsmanship_id" = "craftsmanships"."id"
        LEFT JOIN "users" ON "users"."id" = "contractor_skills"."user_id"
WHERE (contractor_skills.user_id = 8
        OR contractor_skills.user_id IS NULL)
ORDER BY
        "craftsmanships"."id”;

Gives correct result. Not sure if still this query has bug in it.