joining 2 recordets from 2 sources

[raysql]

Hi,

I have 2 databases, and from that i have created 2 recordsets in an ASP page. (Using Dreamweaver!)

The 2 recordsets are:

<%
Dim rs_A55report
Dim rs_A55report_numRows

Set rs_A55report = Server.CreateObject("ADODB.Recordset")
rs_A55report.ActiveConnection = MM_T720i_STRING
rs_A55report.Source = "SELECT * FROM [T720ii report]"
rs_A55report.CursorType = 0
rs_A55report.CursorLocation = 2
rs_A55report.LockType = 1
rs_A55report.Open()

rs_A55report_numRows = 0
%>
<%
Dim rs_special
Dim rs_special_numRows

Set rs_special= Server.CreateObject("ADODB.Recordset")
rs_special.ActiveConnection = MM_login1_STRING
rs_special.Source = "SELECT * FROM Specialist"
rs_special.CursorType = 0
rs_special.CursorLocation = 2
rs_special.LockType = 1
rs_special.Open()

rs_special_numRows = 0
%>

Both recordsets contain the field "Email_Address". I need to produce/display all the records in "rs_A55report" that have a match for the "Email_Address" in the recordset "rs_special"...

Its basically a joing with an Intersect fucntion but i don't know how to impliment it, or i might be able to do this via VB script and ASP????

Any help would be greatly appreciated

Ray

 

[PHV]

You may consider a Dictionary object.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244