有以下两个表:
我如何通过查询获得与 2 个或更多同名结婚的女性的姓名?
因为这样我只会得到女性的 cf,但不能得到名字:
select distinct matrimonio.cfmoglie
from matrimonio inner join persona
on matrimonio.cfmarito=persona.codfis
AND (NOME,CODFIS) IN
(SELECT a.NOME,a.CODFIS
FROM PERSONA a
JOIN PERSONA b
ON a.NOME=b.NOME and a.CODFIS!=b.CODFIS)
group by cfmoglie
having count(cfmoglie)>1;