title: Syntax Error with FROM clause
body: <p>EXTREME noob, here. Just started learning SQL about a week ago and working through the basics.
  Anyway, I'm using Microsoft Access 2010 right now and just found out how to run SQL queries on it (was using DB Browser before). But now I've run into a bit of a pickle.</p>
  
  <p>I have several tables; Orders, Products, Customers, and SalesReps (my own little test project) and I'm trying to display the Orders up but I want to join the results from the Products table so I can, eventually, total up the cost for each order and work out the profit. Anyway, one step at a time.</p>
  
  <p>Here's my issue:</p>
  
  <pre><code>SELECT Products.SKU
  FROM [Products]
  JOIN [Orders];
  </code></pre>
  
  <p>That's my query right now. Really basic. But, for some reason, I keep getting the 'Syntax Error with FROM clause' and I'm not sure why. I tried removing the JOIN command and it works perfectly. I've even reversed the order so I'm joining the Products table onto the Orders table, AND I've tried using INNER/OUTER JOIN as well but the problem remains the same. It's probably something extremely stupid so I apologize in advance...</p>
  
  <p>Any tips? Again, I'm an extreme noob here so please bear that in mind when you're writing your answers. Thanks! </p>
  
  <p>Just FYI, this is probably the most 'advanced' thing I know right now; how to join tables. Just to give you an idea on where my knowledge extends to.</p>
  
  <p>Also update on my dilemma. I dropped SQL for a bit, bit going on, and just came back to it now.</p>
  
  <p>Here is my new query:</p>
  
  <pre><code>SELECT Orders.Product, Orders.Quantity
  FROM Orders
  JOIN Products
  ON Orders.Product = Products.SKU;
  </code></pre>
  
  <p>and I'm still getting the Syntax error in FROM clause error. </p>
  
  <p>Still not seeing the error.</p>
  
  <p>Thanks</p>