select * from PCISIMP2U pcisimp2u left outer join PCISIMP1U pcisimp1u on pcisimp1u.idpk = pcisimp2u.idpk_1u