Hello List! Does anybody know how to select and build a result set from two or more databases with the same table structures that are on the same server.
I need the query to select the data from table1 on db1 and then select the data from table1 on db2 and return a result of where if a field data value is found in both tables that matches on name for example, it would count the occurrences. Thanks in advance Craig