title: Trouble with select statement on three table join
body: <p>Im trying to write a query that will return a set of columns from three different tables.</p>
  
  <p>The table that is link between the other two tables is called Table_A, it contains the keys of for the other two tables.
  The second table is called the Table_B and the last table is called the Table_C.</p>
  
  <p>Table_A columns.</p>
  
  <blockquote>
    <p>| a_ID (primary key)| b_ID (foreign key)| c_ID
    (foreign key)| ..... |</p>
  </blockquote>
  
  <p>Table_B columns</p>
  
  <blockquote>
    <p>|b_ID (primary key)| b1 | b2 | ...... |</p>
  </blockquote>
  
  <p>Table_C columns</p>
  
  <blockquote>
    <p>| c_ID (primary key) | c1 | c2 | ...... |</p>
  </blockquote>
  
  <p>This is my SQL Query below. (Im only concerned with the columns above although there are more in each table.)</p>
  
  <pre><code>SELECT b.b_ID
       , b.b1
       , b.b2
       , a.a_ID
       , c.c1
       , c.c2 
  FROM Table_A AS a 
      JOIN Table_B AS b ON a.b_ID = b.b_ID
      JOIN Table_C AS c ON a.c_ID = c.c_ID
  </code></pre>
  
  <p>Im using open office for my projects and the error I'm getting is</p>
  
  <blockquote>
    <p>"Table not found in statement [    SELECT b.b_ID
             , b.b1
             , b.b2
             , a.a_ID
             , c.c1
             , c.c2 
        FROM Table_A AS a 
            JOIN Table_B AS b ON a.b_ID = b.b_ID
            JOIN Table_C AS c ON a.c_ID = c.c_ID]"</p>
  </blockquote>
  
  <p><em><strong>For some reason if I change the select statement just to get all columns (</em>*</strong>) it returns the correct results but I need to narrow it down to the columns listed in my query.<em>*</em></p>
  
  <pre><code>SELECT *
  FROM Table_A AS a 
      JOIN Table_B AS b ON a.b_ID = b.b_ID
      JOIN Table_C AS c ON a.c_ID = c.c_ID'
  </code></pre>
  
  <p>EDIT: I have removed the actual table and column names so that you don't have to understand the story to help with the issue.</p>