SELECT cclf.FIELDNAME AS verificationTabel
       CASE ccclf.ISVISIBLE
            WHEN 'Y'
            THEN 'true'
            ELSE 'false'
       END as ISVISIBLE,
FROM CCPCLIENTLOGS_FIELDS cclf
LEFT JOIN CUSTCCPCLIENTLOGS_FIELDS ccclf
     ON ccclf.FIELDS_ID = cclf.ID AND ccclf.CUSTOMER_ID =2746
ORDER BY clf.ID
WHERE cclf.ISACTIVE='Y';