insert into Warehouse values(‘A1’,‘CA1004322’,‘Q100000’)
insert into Warehouse values(‘A2’,‘CB1003113’,‘Q100000’)
insert into Warehouse values(‘A3’,‘CC1003422’,‘Q100000’)
insert into Warehouse values(‘A4’,‘CD1002432’,‘Q100000’)
insert into Warehouse values(‘A5’,‘CE1000432’,‘Q100000’)
insert into Warehouse values(‘A6’,‘CF1000045’,‘Q100000’)
insert into Warehouse values(‘A7’,‘CG10043242’,‘Q1000003’)
insert into Warehouse values(‘A8’,‘CH10031413’,‘Q1000003’)
insert into Warehouse values(‘A9’,‘CL10034422’,‘Q1000003’)
insert into Warehouse values(‘A6’,‘CD10024432’,‘Q1000003’)
insert into Warehouse values(‘A5’,‘CE10004432’,‘Q1000003’)
insert into Warehouse values(‘A6’,‘CF10004045’,‘Q1000003’)
insert into Warehouse values(‘V1’,‘CUT10043242’,‘RT000345’)
insert into Warehouse values(‘V5’,‘UIY10031413’,‘RT000345’)
insert into Warehouse values(‘V4’,‘UY10034422’,‘RT000345’)
insert into Warehouse values(‘AB2’,‘RTD10024432’,‘RT000345’)
insert into Warehouse values(‘TR’,‘TR10004432’,‘RT000345’)
insert into Warehouse values(‘R3’,‘YF10004045’,‘RT000345’)
select sequence 编号, Type as 零件名,bacode 条码 from Warehouse