title: Oracle SQL - Select from two tables
body: <p>I have two tables which are exactly the same layout, but have different data (one is current, one is history).</p>
  
  <p>How do I pull information from both tables?</p>
  
  <p>PSUDO SQL:</p>
  
  <pre><code>SELECT 
      T.TRANS_QUAN,
      P.PONO, D.ID
  FROM 
      TRANSLOG T, (select * from PO, PO_HIST) P, (SELECT * FROM PO_DETAIL, PO_DETAIL_HIST) D
  WHERE 
      D.PO_ID = P.ID
      AND T.SOURCE_ID = D.ID
  </code></pre>
  
  <p>When I try to actually run that I get "column ambiguously defined"</p>