【批量】多条件批量查询语句

    <select id="getSameCarton" resultType="java.lang.Integer">
        select count(1)
        from
        (
        <foreach collection="qrTableList" item="qrTable" separator=" union all ">
            select * from ${qrTable}
        </foreach>
        ) t
        where
        1=1
        and
        <foreach collection="printQrList" item="qr" separator="or" open="(" close=")">
            purchase_order_no=#{qr.purchaseOrderNo}
            and
            purchase_order_line_number =
            #{qr.purchaseOrderLineNumber}
            and
            carton
            =#{qr.carton}
        </foreach>
    </select>