CODE EXAMPLE FOR SQL

postgresql not in alternative

SELECT  l.id, l.value
FROM    t_left l
LEFT JOIN
        t_right r
ON      r.value = l.value
WHERE   r.value IS NULL