create table biao1
(
字段a char(1),
字段b char(1),
字段c char(1)
)
insert into biao1 select '1','2','3'
create table biao2
(
字段a char(1),
字段b char(1),
字段c char(1),
其他 char(2)
)
insert into biao2 select '1','5','3','kk'
union all select '2','2','7','ll'
union all select '1','2','3','hh'
union all select '1','3','3','yy'
select * from biao2 where not exists(select * from biao1 where biao1.字段a=biao2.字段a and biao1.字段b=biao2.字段b and biao1.字段c=biao2.字段c)
drop table biao1,biao2