闲来无事出个问题考考大家！，不难，难不难,不难，难不难,不难，难不难！

[gdmm]

表1

id name
1 a.aaaa
2 a.bbbb
3 a.cccc
4 a.dddd

表2

id aid name
1 1 b.aaaa
2 1 b.bbbb
3 2 b.cccc
4 2 b.dddd

select a.id,a.name,b,id,b,name from t1 as a,t2 as b where b.aid=a.id
........

Do while not rs.eof
....................
rs.movenext
loop

显示数据如下：

a.id a.name b.name

1 a.aaaa b.bbbb
2 a.aaaa b.aaaa
3 a.bbbb b.aaaa
4 a.bbbb b.bbbb

试问阁下，如何去掉表1记录在表2中的重复记录
即只显示：

a.id a.name b.name

1 a.aaaa b.bbbb
2 a.bbbb b.aaaa

[vulcan]

left out join?

[Reker熊]

select a.id,a.name,b.id,b.name from t1 a join t2 b on a.id=b.id and substring(a.name,3,4)<>substring(b.name,3,4)

[cqfeng]

where right(a.name,4) <> right(b.name,4)

[zyxwh]

多层select
select unique a.id,a.name,b.name from
(select ...)

[zyxwh]

应该是用 distinct