select * from v_wms_base_location lo
left join v_wms_base_zone zo on (lo.zone_id=zo.id)
left join v_wms_item_location_map ma on (ma.loc_id=lo.id)
left join v_wms_inv_detail de on (lo.id=de.loc_id)
where UPPER(lo.LOC_CODE) LIKE '%' || UPPER('s') || '%' and ma.id is null
and (de.qty=0 or de.qty is null)这什么问题? 到ORACLE上运行没问题啊
left join v_wms_base_zone zo on (lo.zone_id=zo.id)
left join v_wms_item_location_map ma on (ma.loc_id=lo.id)
left join v_wms_inv_detail de on (lo.id=de.loc_id)
where UPPER(lo.LOC_CODE) LIKE '%' || UPPER('s') || '%' and ma.id is null
and (de.qty=0 or de.qty is null)这什么问题? 到ORACLE上运行没问题啊
<![CDATA[
select * from v_wms_base_location lo
left join v_wms_base_zone zo on (lo.zone_id=zo.id)
left join v_wms_item_location_map ma on (ma.loc_id=lo.id)
left join v_wms_inv_detail de on (lo.id=de.loc_id)
where UPPER(lo.LOC_CODE) LIKE '%' || UPPER(#LOC_CODE#) || '%' and ma.id is null
and (de.qty=0 or de.qty is null)]]>
</select> 这是ibatis代码
这个条件没看明白