SQL Server 2017

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table t1(pname varchar(10), fid int);
insert into t1(pname, fid) values
('Dog', 1), ('Dog', 2), ('Cat', 2), ('Cat', 3);
4 rows affected

create table t2(pname varchar(10), fid int);
insert into t2(pname, fid) values
('Dog', 1), ('Cat', 2), ('Cat', 4);
3 rows affected

select t1.*
from t1 left join t2
on t1.pname = t2.pname and t1.fid = t2.fid
where t2.pname is null and t2.fid is null


pname
fid


Dog
2

Cat
3