Product(产品)
product_code
product_name
product_desc
created_date
Supplier(供应商)
supplier_code
supplier_name
address_1
address_2
address_3Part(基本零件)
part_code
part_name
part_desc
reProduct_comp(产品大部件)
product_code
comp_id
number_component
Component(部件结构)
comp_id
component_code
parent_component_code
component_name
supply_id
number_component
component_supply(零件供应)
supply_id
part_code
supplier_code
price
ind_activeProd_part_supp_detail(产品零件明细)
product_code
supply_id
number_component这几张表编写procedure 或function生成指定产品的产品零件明细清单
要求显示
Supplier Name Part Name Necessary Num Amount Type
xxxxxxxx xxxx xxx xx xx xx Write a SQL to display the supplier and component code detail for the product. If the “Amount” < 1000 show “Low”, if “Amount” >=1000<10000 show “Middle”, else show “High”
那位牛人能OK? 留下QQ 联系
你这样也做不好程序的。
碰到具体问题再问。