select ren.PINAME,pivf.PIVFNAME,br.BRPATH,piv.PIVREV,piv.PIVVER from (select distinct pi.PINAME from pdm.PDM_PRODUCTITEM pi, pdm.PDM_BRANCH br, pdm.PDM_PRODUCTITEMVERSION piv, pdm.PDM_PRODUCTITEMVERFILE pivf where pi.PIID=br.PIID and piv.BRID=br.BRID and piv.PIVID=pivf.PIVID and pi.PINAME!=pivf.PIVFNAME group by PINAME) ren, pdm.PDM_PRODUCTITEM pi, pdm.PDM_BRANCH br, pdm.PDM_PRODUCTITEMVERSION piv, pdm.PDM_PRODUCTITEMVERFILE pivf where pi.PINAME=ren.PINAME and pi.PIID=br.PIID and piv.BRID=br.BRID and piv.PIVID=pivf.PIVID order by PINAME,PIVFNAME