有T1和T2两张表
T1:fcompanyno,fitemno,fitemname
cqan 1300001 扳手5'寸
cqan 1300002 扳手6'寸
cqan 1300003 扳手7'寸
tjan 1300001 扳手5'寸
tjan 1300002 扳手6'寸
dlan 1300001 扳手5'寸
T2: id,fcompanyno,fitemno,fitemname,fqty,fprice,famount
1, cqan 1300001 扳手5'寸 50 13.5 675
2, cqan 1300005 扳手9'寸 40 12 480
3, tjan 1300002 扳手6'寸 30 12 360
4, tjan 1300006 扳手7'寸 60 15 900
需要查找fcompanyno,fitemno在T2中存在记录,但是在fcompanyno,fitemno中没有的数据
求SQL语句,要求查询结果为:
cqan 1300005 扳手9'寸
tjan 1300006 扳手7'寸
------解决方案--------------------
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