title: database mapping to object
body: <pre><code>SELECT 
  *
  FROM tableA
  INNER JOIN tableB
  ON tableA.id=tableB.tableAref
  </code></pre>
  
  <p>how to fetch the result set of it so that it can identify tableA and tableB fields as different object in php. and also i can map the results in php object.is it possible to map objects in joined query? I know PDO can get the result as object but it does not map the underlying joined tables.</p>