代码:
SELECT CK.RESPERSON AS NAME
FROM CP_KPI_INFO_FY CK, CP_DIM_PROVIDER CP
WHERE CK.PROVIDERID = CP.ID AND CP.ID = case when 变量a='provider' then 'cp.id' else '{1}' end;
- - or
SELECT CK.RESPERSON AS NAME
FROM CP_KPI_INFO_FY CK, CP_DIM_PROVIDER CP
WHERE CK.PROVIDERID = CP.ID AND CP.ID = decode(变量a,'provider',cp.id,变量);