loop through records and disregard equal values

[Drei Divina]

hi everyone, i need some assistance.


i need to compare records from table A (database A) and records from table B (database B) and display list of this records. But i need to filter the list first and disregard agencies in table A that is already existing in table B. Anyway here's a draft of my code:

Set RS = SERVER.CreateObject("ADODB.Recordset")
dts = "SELECT ID,officename,abbrev FROM lu_office ORDER BY ID"
RS.open dts, cn_dts
iddts = RS.getRows()
 
Set RS_map = SERVER.CreateObject("ADODB.Recordset")
map = "SELECT * FROM map_agencies ORDER BY ID_dts"
RS_map.open map,cn_yass
dtsmap = RS_map.getRows()
 
For i = LBound(iddts,2) to UBound(iddts,2)
    if iddts(0,i) <> dis then
    For j = LBound(dtsmap,2) to UBound(dtsmap,2)
        if iddts(0,i) <> dtsmap(1,j) then
            Response.Write iddts(0,i) &" - "&dtsmap(1,j)&"<br>"
        end if
        if iddts(0,i) = dtsmap(1,j) then
            dis = dtsmap(1,j)
            Response.Write "DO NOT SHOW THIS: " & dtsmap(1,j) & "<br>"
            exit For
        end if
    next
    end if
next
 

its fine until for i loop for the third time coz the list again shows records existing in table B.

need help badly.
Thanks in advance!

[jhardman]

Look up the sql keyword "union", see if that answers your question (by default disregards duplicates in two different tables).

Jared