oracle查询,依据一个字段的值,去判断是否查另一个值--有道笔记整理

want_water_fish

于 2015-11-19 17:45:12 发布

阅读量3.1k

点赞数

本文链接：https://blog.csdn.net/want_water_fish/article/details/49931099

版权

SELECT TO_NUMBER(CASE
                   WHEN FFXNUM >= 1 THEN
                    (SELECT RE.BNDG_VAL
                       FROM OLN_EVENT_RELAT RE
                      WHERE RE.EVENT_NO = '32'
                        AND RE.BNDG_CD = '13')
                   ELSE
                    '0'
                 END) AS FXNUM 
  FROM (SELECT COUNT(*) AS FFXNUM
          FROM OLN_MBR_EVENT_PTCP ME
         WHERE ME.EVENT_NO = '32'
           AND ME.MBR_NO = 'M378571')