56,673
社区成员
发帖
与我相关
我的任务
分享
select A.*,B.*
from A,B
where A.itemcode=B.itemcode and A.kind<>B.kind
select A.*,B.*
from TESTA A,TESTB B
where A.itemcode=B.itemcode and A.kind<>B.kind
select A.*,B.*
from A,B
where A.itemcode=B.itemcode and A.kind<>B.kind
select *
From 表TestA a inner join 表TestB b On a.itemcode=b.itemcode
where a.Kind!=b.Kind