选择相关表中没有值为的记录的所有行

我会用 not exists

select p.*
from person p
where not exists (select 1
                  from files f
                  where f.person_id = p.id and f.type = 'Photo'
                 );

为了提高性能,您需要一个索引 files(person_id, type) .

我会用 not exists :

select p.*
from person p
where not exists (select 1 from files f where f.person_id = p.id and f.type = 'photo');

使用 not in

select p.*
from person p
where p.id not in (select id from Files f where f.type = 'photo');