select * from OFWOS_O1ROLE ofwos_o1role inner join OFWOS ofwos on ofwos.idpk = ofwos_o1role.idpk_ofwos