title: How can I view which employees are available across within any of the 3 different databases with 3 tables
body: <p>If I want to check which Employees(represented by letters) are present across 3 different tables in ANY of three different databases. How should my query look like? I dont want to select the whole table and paste it in excel then do a vlookup. Actually I have 13 Databases which I need to join but I only used three sample databases in my question just to explain what my difficulty is. I just need to know what my query should look like. Im thinking of joining my tables across 12 databases using a subquery. Please help.</p>
  
  <pre><code>    Database1.ResourceTableUS  Database2.ResourceTableUK     Database3.ResourceTableAUS
  col  Employee                   Employee                      Employee
  
  row1  A                         A                             A                   
  row2  B                         C                             B
  row3  C                         I                             C
  row4  E                         J                             K
  row5  F                         K                             N
  row6  H                         N                             T
  
  Answer: A,B,C,K,N - because these are present at least in two tables (B) or three tables (A) in three databases.
  </code></pre>
  
  <p>Thank you!</p>