sql case 用法
sql case 用法
SELECT A.QFBH,A.XH,A.CCFCBZ,C.ZWCM,A0.QFSJ CCQFSJ,(SELECT B.BZ FROM DTYW_FWRQFJCMX B WHERE B.QFJCXMBH = '0104'AND B.QFJCXXBH = '0100024' AND B.QFBH = A.QFBH AND B.XH=A.XH ) QFSH , (SELECT B.BZ FROM DTYW_FWRQFJCMX B WHERE B.QFJCXMBH = '0104' AND B.QFJCXXBH = '0100018' AND B.QFBH = A.QFBH AND B.XH=A.XH ) QFFMMC, A.QFSJFCQFSJ, A.QFDDFCQFDD, (SELECT CASE B.BZ WHEN '0' THEN '否' WHEN '1' THEN '是' WHEN '2' THEN '无' ELSE '' ENDFROM DTYW_FWRQFJCMX B WHERE B.QFJCXMBH = '0104' AND B.QFJCXXBH = '0100021' AND B.QFBH = A.QFBH AND B.XH=A.XH )QFSFWH ,- (SELECT CASE B.SFFHYQWHEN '0' THEN '否' WHEN '1' THEN '是' WHEN '2' THEN '无' ELSE '' END FROM DTYW_FWRQFJCMX B WHERE B.QFJCXMBH = '0104' AND B.QFJCXXBH = '0100025' AND B.QFBH = A.QFBH AND B.XH=A.XH ) QFSHSL , -- (SELECT CASE B.SFFHYQ WHEN '0' THEN '否' WHEN '1' THEN '是' WHEN '2' THEN '无' ELSE '' END FROM DTYW_FWRQFJCMX B WHERE B.QFJCXMBH = '0104'AND B.QFJCXXBH = '0100021' AND B.QFBH = A.QFBH AND B.XH=A.XH ) QFSHYY, - (SELECT CASE B.SFFHYQWHEN '0' THEN '否' WHEN '1' THEN '是' WHEN '2' THEN '无' ELSE '' END FROM DTYW_FWRQFJCMX B WHERE B.QFJCXMBH = '0104' AND B.QFJCXXBH = '0100026' AND B.QFBH = A.QFBH AND B.XH=A.XH) QFSFFZ ,- (SELECT CASE B.SFFHYQ WHEN '0' THEN '否' WHEN '1' THEN '是' WHEN '2' THEN '无' ELSE '' END FROM DTYW_FWRQFJCMX B WHERE B.QFJCXMBH = '0103' AND B.QFJCXXBH = '0100017' AND B.QFBH = A.QFBH AND B.XH=A.XH ) SFCZPWXW FROM DTYW_FWRQFJC A,DTYW_FWRQFJC A0, DTYW_CBJBXX C WHERE A.CBBH = C.CBBH AND A0.CCFCBZ='0'AND A.CCFCBZ='1' AND A.QFBH=A0.QFBH
页:
[1]