我在Oracle SQL上工作,我试图使用where子句过滤一些结果。此外,在同一个查询中,我在选择子句中有大小写。由于某种原因,我在运行查询时遇到错误,我不明白问题是什么。附查询:
SELECT
CASE
WHEN TBL_120.PP_ID!=TBL_200.PP_ID THEN TBL_120.pp_id
END
FROM
(select pp_id, code, amount from price_plan_mapping where pcversion_id =
'10200') TBL_120 LEFT JOIN
(select pp_id, code, amount from price_plan_mapping where pcversion_id =
'20000') TBL_200 ON TBL_120.PP_ID=TBL_200.PP_ID
WHERE TBL_120.PP_ID!=TBL_200.PP_ID IS NOT NULL
我想用 null 填充来自案例编码的所有结果。
感谢您的帮助
WHERE TBL_120.PP_ID != TBL_200.PP_ID IS NOT NULL
可能应该是
WHERE TBL_120.PP_ID != TBL_200.PP_ID
AND TBL_200.PP_ID IS NOT NULL