select *
from spf spf
left outer join spe spe on spe.spe_idpk = spf.spf_spe_idpk