SELECT
*
FROM
M_SHARE_EXP
INNER JOIN FRM_SHARE_EXP on M_SHARE_EXP.SHARE_EXP_ID = FRM_SHARE_EXP.WFR_ID
INNER JOIN WF_FILE ON FRM_SHARE_EXP.F_ID = WF_FILE.WFR_ID
WHERE
WF_FILE.WFS_FIELD_NAME = 'SHARE_IMAGE'
AND WF_FILE.WF_MAIN_ID = '57841'
AND WF_FILE.FILE_STATUS = 'Y'
AND M_SHARE_EXP.SHARE_EXP_ID = '' Error Description: ERROR: invalid input syntax for type numeric: ""
LINE 11: AND M_SHARE_EXP.SHARE_EXP_ID = ''
^
/
