if Im trying to delete duplicates by comparing two columns from two different tables and each table has too many rows to do a simple delete query what would be the best possible solution should I create a function like
rs.open"select * from table"
rs2.open"select distinct column1 from table"
do until rs.eof
if rs.column1 = rs2.colunmn then