select * from OFWGRPDEF ofwgrpdef left outer join OFWGRP ofwgrp on ofwgrp.idpk = ofwgrpdef.idpk_ofwgrp