title: Selecting More Than 1 Table in A Single Query
body: <p>I have 5 Tables in MS Access as</p>
  
  <pre><code>Logs [Title, ID, Date, Author]
  Tape [Title, ID, Date, Author]
  Maps [Title, ID, Date, Author]
  VCDs [Title, ID, Date, Author]
  Book [Title, ID, Date, Author]
  </code></pre>
  
  <p>I tried my level best through this code</p>
  
  <pre><code>SELECT Logs.[Author], Tape.[Author], Maps.[Author], VCDs.[Author], Book.[Author]
  FROM Logs
     , Tape
     , Maps
     , VCDs, Book
  WHERE ((([Author] &amp; " " &amp; [Author] &amp; " " &amp; [Author] &amp; " " &amp; [Author]&amp; " " &amp; [Author])        
  Like "*" &amp; [Type the Title or Any Part of the Title and Press Ok] &amp; "*"));
  </code></pre>
  
  <p>I want to select all of these fields in a single query. Suppose there is Adam as author of works in all tables. So when i put Adam in search box it should result from all tables.</p>
  
  <p>I know this can be done by having single table or renaming fields names but that's not required.</p>
  
  <p>Please help.</p>