日期:2014-05-17 浏览次数:20438 次
create table T1(fcompanyno varchar(10),fitemno varchar(10),fitemname varchar(10))
insert into T1
select 'cqan',1300001,'扳手5''寸'
union all select 'cqan',1300002,'扳手6''寸'
union all select 'cqan',1300003,'扳手7''寸'
union all select 'tjan',1300001,'扳手5''寸'
union all select 'tjan',1300002,'扳手6''寸'
union all select 'dlan',1300001,'扳手5''寸'
create table T2(id int,fcompanyno varchar(10),fitemno varchar(10),fitemname varchar(10),
fqty int ,fprice numeric(12,2),famount numeric(12,2))
insert into T2