Hello everyone!<BR>I am retrieving data from table_2, if it exists in table_1 in the fieldAb then I have to add field Bc to field C.Code below:<BR><BR> &#060;%dim rsSt(2)<BR> dim sqlSt(2)<BR> dim z<BR> dim dicStatus<BR> <BR>Set dicStatus = Server.CreateObject("Scripting.Dictionary")<BR>Set rsSt(0) = Server.CreateObject("adodb.recordset")<BR>Set rsSt(1) = Server.CreateObject("adodb.recordset")<BR> <BR>sqlSt(0) = "SELECT Ab, Bc FROM table_1 "<BR>sqlSt(1) = "SELECT C FROM table_2"<BR> <BR>for z = 0 to 1<BR> rsSt(z).Open sqlSt(z),conn,3,2<BR> do until rsSt(z).EOF<BR> if not dicStatus.Exists(rsSt(z).Fields(0).Value) then dicStatus.Add rsSt(z).Fields(0).Value,""<BR> rsSt(z).movenext<BR>loop<BR> next%&#062;<BR>If anybody could help would be really great!<BR>Thank you in advance!<BR><BR>