查询表中不相等的记录

[tfish2014]

如
表TestA 记录如下：
itemcode Kind
A A01
B B01
C C01
表TestB 记录如下：
itemcode Kind
A A01
B B01
C B02



查询2表中ITEMCODE字段相同，KIND字段不相等的所有记录

查询结果：
ITEMCODE1 KIND1 ITEMCODE2 KIND2
C C01 C B02

[ACMAIN_CHM]

select *
From 表TestA a inner join 表TestB b On a.itemcode=b.itemcode
where a.Kind!=b.Kind

[rucypli]

select A.*,B.*
from A,B
where A.itemcode=B.itemcode and A.kind<>B.kind

[wwwwb]

select A.*,B.*
from A,B
where A.itemcode=B.itemcode and A.kind<>B.kind

or
select * from a left join b on A.itemcode=B.itemcode and A.kind=B.kind where b.kind is null

[lxq19851204]

select A.*,B.*
from TESTA A,TESTB B
where A.itemcode=B.itemcode and A.kind<>B.kind

[zuoxingyu]

select A.*,B.*
from A,B
where A.itemcode=B.itemcode and A.kind<>B.kind