SELECT NAME_TITLE_TH , NAME_TITLE_EN , LINK_DATA , TYPE_FILE_LINK ,
(SELECT FILE_SAVE_NAME
FROM WF_FILE
WHERE WF_MAIN_ID = 57936
AND WFR_ID = M_KUSAM_PHOTO_VIDEO.M_ID
AND FILE_STATUS = 'Y') AS FILE_NAME
FROM M_KUSAM_PHOTO_VIDEO
WHERE 1=1
AND ACTIVE_STATUS = 'Y'
AND TYPE_DATA = 1
ORDER BY M_ID DESCError Description: ERROR: operator does not exist: character varying = integer
LINE 13: AND TYPE_DATA = 1
^
HINT: No operator matches the given name and argument types. You might need to add explicit type casts.