title: I get error when I write these lines in the SQL View of Access
body: <p>I was studying DBMS by using a book. In the book, the instructions are done by using Access. In the SQL View of the Query, the book says that I should write these lines to use JOIN operation and create another table. Yet, when I write them in the SQL View, I get error messages. I could not figure out this problem. Is it wrong that I use wrong syntax or something else that I don't know? Following code which is written in the book demonstrates the operation that I want to do.</p>
  <pre><code>JOIN Customer Rep
  WHERE Customer.RepNum = Rep.RepNum
  GIVIN Temp
  PROJECT Temp Over(CustomerNum,CustomerName,RepNum,LastName)
  GIVING Answer
  </code></pre>