title: count records in two different access file using query
body: <p>I have two ms access 2003(.mdb) file one is student record the other is the test scores.</p>
  
  <pre><code>student record.mdb contents
  tables:
  basicinfo
  schoolsattended
  familyinfo
  
  test scores.mdb contents
  tables:
  verbal
  written
  </code></pre>
  
  <p>as you can see my student record.mdb has 3 table and the test score.mdb has 2, the important tables are only basicinfo, verbal and written dont mind the rest. what i want to do is count how many students got the specific scaled score using query for verbal and written as shown below.</p>
  
  <pre><code>[basicinfo](table1-student record.mdb)
  [Name     age     rawscoreverbal    rawscorewritten](fields)
  mark      16      6                 6
  paul      17      5                 5
  bryan     16      8                 8
  jenny     16      7                 7
  
  verbal(table1-test scores.mdb)
  [rawscore     scaledscore](fields)
  1                1
  2                1
  3                2
  4                2
  5                3
  6                3
  7                4
  8                4
  9                5
  10               5
  
  writen(table2-test scores.mdb)
  [rawscore     scaledscore]fields
  1                1
  2                1
  3                2
  4                2
  5                3
  6                3
  7                4
  8                4
  9                5
  10               5
  
  expected output
  
  Verbal:
  Scaled Score      Count
  1                 0
  2                 0
  3                 2
  4                 2
  5                 0
  
  written:
  Scaled Score      Count
  1                 0
  2                 0
  3                 2
  4                 2
  5                 0
  </code></pre>
  
  <p>I've tried using this code</p>
  
  <pre><code>SELECT v.scaledscore as [Scaled Score], count(i.rawscore) as [Count]
  FROM verbal v LEFT JOIN basicinfo i ON v.rawscore = i.rawscore
  GROUP BY v.scaledscore
  </code></pre>
  
  <p>it works but only if all tables are together in one .mdb file. But i need two separate .mdb files since i have something else to do with it. I dont wanna explain it since its a very long story. Is it possible? if it is, can anyone help me?</p>