oracle使用LEFT JOIN关联产生的问题在查询结果中使用CASE WHEN 无法判断
查询方式一:
SELECT
CASE WHEN (SELECT CAST(SUM(CASE
WHEN (ALLOCABLE_PRIME_CURRENCY_VALUE IS NULL AND STATE_IND = 1) THEN
NVL(...
oracle使用LEFT JOIN关联产生的问题在查询结果中使用CASE WHEN 无法判断
查询方式一:
SELECT
CASE WHEN (SELECT CAST(SUM(CASE
WHEN (ALLOCABLE_PRIME_CURRENCY_VALUE IS NULL AND STATE_IND = 1) THEN
NVL(...