sql ibatis

<!-- 写入单位下当前参保人员 -->
    <insert id="insertTempCaz043" parameterClass="map">
        INSERT INTO TEMP_CAZ043 (AAC001,
                                 HDID,
                                 aae001,
                                 cab623
                                 )
                 SELECT DISTINCT a.AAC001,
                                 #hdid#,
                                 #aae001#,
                                 #cab623#
                            FROM AC02 a, ac01 b
                           WHERE A.AAB001 = #aab001#
                             AND A.AAC001 = B.AAC001
                             AND B.AAC084 = '0'
                             AND A.AAC008 = '1'  <!-- 正常参保 -->
                             AND A.AAE042 IS NULL
    </insert>

 

posted @ 2019-11-05 10:18  moonsoft  阅读(83)  评论(0编辑  收藏  举报