select * from PID_HL pid_hl left outer join PUCPRIPAD pucpripad on pucpripad.idpk = pid_hl.idpk_pripad