title: mySQL error #1054 Why is my inner join not working? (Rookie Level)
body: <pre><code> SELECT `orders.customerNumber`, `orders.orderNumber`, `orders.orderDate`, `payments.customerNumber`, `payments.amount`
  From `Orders`
  INNER JOIN `Payments`
  ON Payments.customerNumber=Orders.customerNumber;
  </code></pre>
  
  <p>I don't understand what I'm doing wrong. Syntax issue perhaps?
  Thank you for your time, I really appreciate it.</p>