17,086
社区成员
发帖
与我相关
我的任务
分享
select checkvaluetable.* from checkvaluetable@test inner join checkfile@test on checkvaluetable.filename = checkfile.filename ]]><![CDATA[
where checkfile.filename like '%{1}%' and
(case when '{2}' = 'ISKeylack' then checkfile.ISKeylack
when '{2}' = 'ISCiNoExist' then checkfile.ISCiNoExist
when '{2}' = 'ISFMPMMatching' then checkfile.ISFMPMMatching
when '{2}' = 'ISNotReal' then checkfile.ISNotReal
when '{2}' = 'IS30PER' then checkfile.IS30PER
else checkfile.ISConFiveDay end) = 'true'
select keyvaluetable.* from keyvaluetable inner join checkfile on keyvaluetable.filename = checkfile.filename
where checkfile.filename like '%{1}%' and
case when 'FDESC' = 'FDESC' then checkfile.fdesc like '%没有通过%'
else checkfile.ISKEYLACK = 'true' end
SELECT KEYVALUETABLE.*
FROM KEYVALUETABLE
INNER JOIN CHECKFILE ON KEYVALUETABLE.FILENAME = CHECKFILE.FILENAME
WHERE CHECKFILE.FILENAME LIKE '%{1}%'
AND (CHECKFILE.FDESC LIKE CASE WHEN 'FDESC' = 'FDESC' THEN '%没有通过%' ELSE NULL END
OR
CHECKFILE.ISKEYLACK = CASE WHEN 'FDESC' = 'FDESC' THEN NULL ELSE 'true' END)
;