title: SQL statement to get all customers with no orders
body: <p>I have a typical Persons table and an Orders table defined in such a way that I can do JOIN query as the following to return Orders for all Persons.</p>
  
  <pre><code>SELECT Persons.LastName, Persons.FirstName, Orders.OrderNo
  FROM Persons
  INNER JOIN Orders
  ON Persons.id=Orders.Person_id
  </code></pre>
  
  <p>The question is, how do I write a statement that would return all Persons with NO Orders? </p>
  
  <p>I'm using mysql.</p>
  
  <p>Thank all in advance.</p>