using 2 database for Listview function

[si_the_geek]

Do you want to return data from both tables in the same recordset?

If not, then basically what you had before (but you need to at least answer my second question above to be sure this is right).

If you do want it all in the same RS, use SQL like this:

SELECT TableA.Field1, TableB.Field2, ...
FROM TableA INNER JOIN TableB ON (TableA.FieldC = TableB.FieldC)
ORDER BY ....