title: How do I write SQL to get objects
body: <p>I have a table in a MySQL table called persons</p>
  
  <pre>
  id  LastName    FirstName
  1       Hansen      Timoteivn
  2       Svendson    Tove
  3       Pettersen   Kari
  </pre>
  
  <p>and another MySQL table called orders.</p>
  
  <pre>
  id  OrderNo  personID
  1       77895    3
  2       44678    3
  3       22456    1
  4       24562    1
  5       34764    15
  </pre>
  
  <p>How can I write a SQL query that I feed into PHP's <code>mysql_query()</code> function to return a list of "Order objects" that each contain a "Person object?" Each "Person object" has first name and last name as properties.</p>