Here is what I want to doon my asp page I have following tableA B C D E Fcolumn A,B,C is from sql database db1, Column D, E is from sql database db2, F is D-CThis is what I did so far ://making connection to db1 //set rs.open for db1//while not rs.eof//making connection to db2//set rs2.open for db2//while not rs2.eof//do something, get some values from both db1 and db2//<td class="line">rs("comlumna")//<td class="line">rs2("comlumne") //here i want to add a, b, c, d, e, value to the table//rs2.movenext//close connection to db2//rs1.movenext//close neection to db1but this doesn't work , can anyone help me to find out where is the problem ?thanks