SELECT DISTINCT test1.XXX,Test2.YYY FROM Test1,Test2 WHERE Test1.userid=Test2.userid
如果你想删除test2中的重复记录,可以写这样一个SQL语句: delete From test2 Where userid In (Select userid From test1)
谢谢二楼的,问题还没有完全弄清楚,我用下面的语句删除了表access_log和表permissions复重的userid值的记录,但是我一次只能删除access_log中与permissions重复的记录,怎样同时删除persissions表中与access_log表中重复的记录? db.Execute "delete From access_log Where userid In (Select userid From permissions)"
delete From test2 Where userid In (Select userid From test1)
db.Execute "delete From access_log Where userid In (Select userid From permissions)"