newbie question - how to list people who has not email address related to him/her?
Aliases should be short and meaningful
select pe.c_id as &quot;ID&quot;, 
    pe.c_family_name as &quot;Family Name&quot;,
    pe.c_last_name as &quot;Last Name&quot;,
    em.c_email as &quot;Email&quot;
    
from
t_people pe
LEFT JOIN t_ref_email re ON re.c_party = pe.c_id
LEFT JOIN t_email em ON em.c_id = re.c_email

With the result of
ID      Family Name     Last Name   Email
1000    Test            Joe         test_email@email.com
1001    Test             Bill        (null)