如题,一次sql查询语句中EXIST子句是否只能有一个吗?各位帮忙看看下边的语句错误在哪SELECT DKSG.LOT_SETSUBI_CD,
DKSG.LOT_NO, DKSG.KANRI_KOTEI_CD,
MKKT.KANRI_KOTEI_NAME, DKSG.SETSUBI_CD,
DKSG.SAGYOSHA_NO, MSSH.SAGYOSHA_NAME,
DKSG.SAGYO_KOUSU, DKSG.SAGYO_START_DATE,
DKSG.SAGYO_END_DATE,
CASE DKSG.SAGYO_STATUS WHEN 0 THEN '作業中' WHEN 1 THEN '完了' END
FROM RDDATAV4.SO.D_KOTEI_SAGYO AS DKSG
JOIN MSDATAV4.SO.M_KANRI_KOTEI AS MKKT
ON DKSG.KANRI_KOTEI_CD = MKKT.KANRI_KOTEI_CD
JOIN MSDATAV4.SO.M_SAGYOSHA AS MSSH
ON DKSG.SAGYOSHA_NO = MSSH.SAGYOSHA_NO
WHERE 1=1 AND DKSG.SAGYO_SHIJI_GENNO>=@GEN_NO_FROM
AND DKSG.SAGYO_SHIJI_GENNO<=@GEN_NO_TO
AND DKSG.LOT_SETSUBI_CD=@LOT_NO_SETSUBI
AND DKSG.LOT_NO=@LOT_NO AND DKSG.KANRI_KOTEI_CD=@KANRI_KOTEI_CD
AND DKSG.SETSUBI_CD=@SETSUBI_CD AND DKSG.SAGYOSHA_NO=@SAGYOSHA_NO
AND DKSG.SAGYO_START_DATE>=@SAGYOBI_FROM
AND DKSG.SAGYO_END_DATE<=@SAGYOBI_TO AND EXIST(SELECT * FROM RDDATAV4.SO.D_JUCHU AS DJCH_1, RDDATAV4.SO.D_KOTEI_SAGYO AS DKSG_1
WHERE DJCH_1.GENPINHYO_NO=DKSG_1.SAGYO_SHIJI_GENNO AND DJCH_1.GENPINHYO_NO>=@GEN_NO_FROM_1
AND DJCH_1.GENPINHYO_NO<=@GEN_NO_TO_1 AND DJCH_1.TOKUISAKI_CD=@TOKUISAKI_CD_1
AND DJCH_1.HINBAN LIKE '%dgfdhfg%' AND DJCH_1.HINNAME LIKE '%hgjhkhj%'
AND DJCH_1.UKETSUKE_DATE>=@UKE_DATE_FROM_1 AND DJCH_1.UKETSUKE_DATE<=@UKE_DATE_TO_1
AND DJCH_1.SHITEI_NOKI_DATE>=@NOKI_DATE_FROM_1 AND DJCH_1.SHITEI_NOKI_DATE<=@NOKI_DATE_TO_1) AND EXIST(SELECT * FROM RDDATAV4.SO.D_JUCHU_SHORI AS DJSR_2, RDDATAV4.SO.D_KOTEI_SAGYO AS DKSG_2
WHERE DJSR_2.GENPINHYO_NO=DKSG_2.SAGYO_SHIJI_GENNO AND DJSR_2.SHORI_CD=@SHORI_CD_2) AND EXIST(SELECT * FROM RDDATAV4.SO.D_KOTEI_SAGYO AS SUB
WHERE SUB.LOT_SETSUBI_CD=DKSG.LOT_SETSUBI_CD AND SUB.LOT_NO=DKSG.LOT_NO
GROUP BY SUB.LOT_SETSUBI_CD, SUB.LOT_NO HAVING MAX(SUB.SAGYO_START_DATE) = DKSG.SAGYO_START_DATE)
DKSG.LOT_NO, DKSG.KANRI_KOTEI_CD,
MKKT.KANRI_KOTEI_NAME, DKSG.SETSUBI_CD,
DKSG.SAGYOSHA_NO, MSSH.SAGYOSHA_NAME,
DKSG.SAGYO_KOUSU, DKSG.SAGYO_START_DATE,
DKSG.SAGYO_END_DATE,
CASE DKSG.SAGYO_STATUS WHEN 0 THEN '作業中' WHEN 1 THEN '完了' END
FROM RDDATAV4.SO.D_KOTEI_SAGYO AS DKSG
JOIN MSDATAV4.SO.M_KANRI_KOTEI AS MKKT
ON DKSG.KANRI_KOTEI_CD = MKKT.KANRI_KOTEI_CD
JOIN MSDATAV4.SO.M_SAGYOSHA AS MSSH
ON DKSG.SAGYOSHA_NO = MSSH.SAGYOSHA_NO
WHERE 1=1 AND DKSG.SAGYO_SHIJI_GENNO>=@GEN_NO_FROM
AND DKSG.SAGYO_SHIJI_GENNO<=@GEN_NO_TO
AND DKSG.LOT_SETSUBI_CD=@LOT_NO_SETSUBI
AND DKSG.LOT_NO=@LOT_NO AND DKSG.KANRI_KOTEI_CD=@KANRI_KOTEI_CD
AND DKSG.SETSUBI_CD=@SETSUBI_CD AND DKSG.SAGYOSHA_NO=@SAGYOSHA_NO
AND DKSG.SAGYO_START_DATE>=@SAGYOBI_FROM
AND DKSG.SAGYO_END_DATE<=@SAGYOBI_TO AND EXIST(SELECT * FROM RDDATAV4.SO.D_JUCHU AS DJCH_1, RDDATAV4.SO.D_KOTEI_SAGYO AS DKSG_1
WHERE DJCH_1.GENPINHYO_NO=DKSG_1.SAGYO_SHIJI_GENNO AND DJCH_1.GENPINHYO_NO>=@GEN_NO_FROM_1
AND DJCH_1.GENPINHYO_NO<=@GEN_NO_TO_1 AND DJCH_1.TOKUISAKI_CD=@TOKUISAKI_CD_1
AND DJCH_1.HINBAN LIKE '%dgfdhfg%' AND DJCH_1.HINNAME LIKE '%hgjhkhj%'
AND DJCH_1.UKETSUKE_DATE>=@UKE_DATE_FROM_1 AND DJCH_1.UKETSUKE_DATE<=@UKE_DATE_TO_1
AND DJCH_1.SHITEI_NOKI_DATE>=@NOKI_DATE_FROM_1 AND DJCH_1.SHITEI_NOKI_DATE<=@NOKI_DATE_TO_1) AND EXIST(SELECT * FROM RDDATAV4.SO.D_JUCHU_SHORI AS DJSR_2, RDDATAV4.SO.D_KOTEI_SAGYO AS DKSG_2
WHERE DJSR_2.GENPINHYO_NO=DKSG_2.SAGYO_SHIJI_GENNO AND DJSR_2.SHORI_CD=@SHORI_CD_2) AND EXIST(SELECT * FROM RDDATAV4.SO.D_KOTEI_SAGYO AS SUB
WHERE SUB.LOT_SETSUBI_CD=DKSG.LOT_SETSUBI_CD AND SUB.LOT_NO=DKSG.LOT_NO
GROUP BY SUB.LOT_SETSUBI_CD, SUB.LOT_NO HAVING MAX(SUB.SAGYO_START_DATE) = DKSG.SAGYO_START_DATE)
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货