List:General Discussion« Previous MessageNext Message »
From:Cx Cx Date:June 24 2006 9:41pm
Subject:selecting data from 2 local DBs with same table structure
View as plain text  
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

Thread
selecting data from 2 local DBs with same table structureCx Cx24 Jun
  • Re: selecting data from 2 local DBs with same table structurePeter Brawley25 Jun
    • Re: selecting data from 2 local DBs with same table structureCx Cx26 Jun