SQL命令未正确结束
街角嘚堕落 2012-03-26 09:38:58 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上运行没问题啊