SELECT  a.profilemaster_pkey,
        a.groupname         ,
        a.profile_name      ,
        b.val               ,
        CASE
                WHEN a.profile_mode='I'
                THEN 'INSERT'
                WHEN a.profile_mode='U'
                THEN 'UPDATE/INSERT'
                WHEN a.profile_mode='D'
                THEN 'DOWNLOAD'
        END "Profile Mode"
FROM
        (SELECT 	m.profilemaster_pkey ,
                	G.GROUPNAME          ,
                	m.profile_name       ,
                	m.profile_mode
        FROM    	FM_PROFILEMAST m
        INNER JOIN	fm_profilegroup G ON G.GROUPID=m.groupid
        ) a                          
RIGHT OUTER JOIN
        (SELECT 	m.profilemaster_pkey ,
                	c.val val
        FROM    	fm_ldr_syntx_dtls dts
        INNER JOIN  fm_profile_cfile c ON dts.syntx_dtls_pkey  = c.ldr_syntx_dtls_pkey
        INNER JOIN	FM_PROFILEMAST m ON c.profilemaster_pkey = m.profilemaster_pkey
        WHERE   dts.parm_stmt_syntx  = 'INFILE '
        ) b
		ON a.profilemaster_pkey = b.profilemaster_pkey
ORDER BY upper(a.groupname);

"There is only one difference between a dream and an aim.
A dream requires soundless sleep to see,
whereas an aim requires sleepless efforts to achieve..!!"

"There is only one difference between a dream and an aim.
A dream requires soundless sleep to see,
whereas an aim requires sleepless efforts to achieve..!!"