CREATE TABLE CCTTAB as 
 select rw.*,jrw.RWVALUE as JVALUE,j2rw.RWVALUE as J2VALUE,j3rw.RWVALUE as J3VALUE
   from CCRW rw
          left outer join CCRW jrw on jrw.RWNAME=rw.RWNAME
          left outer join CCRW j2rw on j2rw.RWNAME=rw.RWNAME
         left outer join CCRW j3rw on j3rw.RWNAME=rw.RWNAME