select APP.APPLICATION_ID,APP.APPLICATION_NAME,X.SMTP_HOST_ID,X.SMTP_HOST,Y.FROM_MAIL_ID_ID, Y.FROM_MAIL_ID FROM (SELECT APPLICATION_ID,PROPERTY_ID SMTP_HOST_ID,PROPERTY_VALUE SMTP_HOST FROM t_gps_app_properties where PROPERTY_NAME = 'SMTP HOST') X, (SELECT APPLICATION_ID,PROPERTY_ID FROM_MAIL_ID_ID,PROPERTY_VALUE FROM_MAIL_ID FROM t_gps_app_properties WHERE PROPERTY_NAME = 'FROM MAIL ID') Y, T_GPS_APPLICATIONS APP WHERE X.APPLICATION_ID = Y.APPLICATION_ID AND APP.APPLICATION_ID = X.APPLICATION_ID AND (APP.VISIBLE_FLAG IS NULL OR APP.VISIBLE_FLAG = 'true') ORDER BY APP.APPLICATION_NAME