我有这个查询
SELECT
*,
CASE
WHEN a.Nama_Merchant = 'SNOOPY SHOP' AND a.Alamat_Merchant <> 'xxx' AND a.Nama_Pemilik = 'HENI' THEN '1'
WHEN a.Nama_Merchant <> 'SNOOPY SHOP' AND a.Alamat_Merchant = 'xxx' AND a.Nama_Pemilik = 'HENI' THEN '1'
WHEN a.Nama_Merchant = 'SNOOPY SHOP' AND a.Alamat_Merchant = 'xxx' AND a.Nama_Pemilik = 'HENI' THEN '1'
ELSE '0'
END AS keterangan
FROM
(SELECT *
FROM merchant_negative_db_Copy mndb
WHERE (Nama_Merchant LIKE 'SNOOPY SHOP' OR Alamat_Merchant LIKE 'xxx' OR Nama_Pemilik LIKE 'HENI')
AND flag_merchant = '0') a
但是当我尝试运行查询时,它显示keterangan返回值0,即使其中一个条件满足要求。
查询结果