<select id="getAll" resultMap="ProductBaseResultMap">
        <iterate property="tables" conjunction="union all">
            select
                  //查询表字段
            from product_base_$tables[]$
            where sku_id in
            <iterate open="(" conjunction="," close=")" property="pks">
                #pks[]#
            </iterate>
        </iterate>
    </select>

	<select id="findProductListByProductIds" resultMap="productMap" parameterClass="java.util.HashMap">
		select
			//字段名
		from $tableName$ p inner join 
		<iterate open="(" close=")" conjunction="union" property="productIdList">
        	<![CDATA[select #productIdList[]# as pid ]]>
		</iterate>
        <![CDATA[as temp     
        	on p.product_id = temp.pid 
		]]>
	</select>