2 u013083822 u013083822 于 2014.02.08 11:01 提问

a.import_list_no,b.import_no,c.GOODS_MODEL,a,b,c,什么意思?

select IMPORT_GOODS_STATUS,a.import_goods_bar, a.import_id,a.import_list_no,b.import_no,c.GOODS_MODEL,c.Goods_standard,c.Goods_unit,c.Goods_type,
a.import_lot_no,import_plan_quantity,import_fact_quantity,import_fulfill_quantity,b.import_date,goods_code,goods_name,
a.import_audit_date,a.import_remark
from wms_import_notifydetail a
left join wms_import_notify b on a.import_id=b.import_id
left join wms_base_goods c on c.goods_id=a.import_goods_id
where a.import_audit_flag='0' and a.import_noused_flag='0' and a.import_upload_flag='0' and a.import_execute_flag='0'
order by a.import_id desc,a.import_list_no asc

a.import_list_no,b.import_no,c.GOODS_MODEL,中的啊a,b,c,什么意思

Csdn user default icon
上传中...
上传图片
插入图片
准确详细的回答,更有利于被提问者采纳,从而获得C币。复制、灌水、广告等回答会被删除,是时候展现真正的技术了!