1.数据表:
(1)t_project表 Project_ID 主键
(2)t_purchasesdetails表 PurDetail_ID 主键
Project_ID 外键
Corpore_ID 外键
(3)t_corporedetail表 Detail_ID 主键(没有用到)
PurDetail_ID 外键
(4)t_corpore表 Corpore_ID 主键
2.sql语句
insert into t_detail(Supplier,Mark,AmountNumber,ProjectName,
Corpore_Name,DetailCorName,Model_Formate,Number,Brand,Unit_Price,DetailTotalPrice,CorMark)
select ta.Supplier,ta.Mark,ta.ContractNo,tb.ProjectName,tc.Corpore_Name,
td.DetailCorName,td.Model_Formate,td.Number,td.Brand,td.Unit_Price,
td.DetailTotalPrice,td.CorMarkshuju
from((t_purchasesdetails ta
left join t_project tb on tb.Project_ID = ta.Project_ID)
left join t_corpore tc on tc.Corpore_ID = ta.Corpore_ID)
left join t_corporedetail td on td.PurDetail_ID = ta.PurDetail_ID;
3.提示:
插入语句字段与查询语句字段一定要对应上。