Another guess: -

SELECT sv.SVSEQ, sc.SCACO, ac.f1 AS AccountNo,

ne.NEAN, ne.NEEAN, bg.BGCFN1, bg.BGCFN2,

bg.BGCFN3, bg.BGCUS, sv.SVNA1, sv.SVNA2,

sv.SVNA3, sv.SVNA4, sv.SVNA5, sv.SVPZIP,

sv.SVCSA, sc.SCACO, sx.SXDLM

FROM NEPF ne

INNER JOIN tmpAccountList ac ON NEEAN = ac.f1

INNER JOIN BGPF bg ON bg.BGCUS = ne.NEAN

INNER JOIN SCPF sc ON sc.SCAN = bg.BGCUS AND bg.BGCUS = ne.NEAN AND sc.SCAN = LEFT(ac.f1, 6)

INNER JOIN sxpf sx ON sx.SXCUS = LEFT(ac.f1, 6)

CROSS APPLY (

SELECT TOP 1 SVSEQ, SVDLM, SVNA1, SVNA2, SVNA3, SVNA4, SVNA5, SVPZIP, SVCSA

FROM SVPF a

WHERE a.SVDLM = sx.SXDLM

ORDER BY SVDLM

) SV;