In ASP I have two record sets, Both record set has field called "CustomerID "
now How can I build third record set where rs1.CustomerID = rs2.CustomerID
Rs1 : All orders
Rs2 : All Customer
How can I write R3 as following
Inner Join RS2 On RS1.CustomerID = RS2.CustomerID
RS1 and RS2 are stored in different DB system therefore I cannot write the join directly.