摘要：
查询 物资明细： SELECT r.material_id,r.material_category,r.material_name,r.material_quality, r.standard,r.product_factory,r.material_type,r.measure_unit,(r.n 阅读全文
摘要：
关联修改： UPDATE scm_material_contract m Left JOIN scm_material_base b ON m.material_id=b.material_id set m.material_name=b.material_name 阅读全文
摘要：
ALTER TABLE scm_material_contract ADD CONSTRAINT material_contract_foreignid FOREIGN KEY(form_id) REFERENCES scm_purchase_contract(contract_id) ALTER 阅读全文