title: How do i select data across two tables using SQL where a field from each table matches?
body: <p>Delphi 2010 &amp; Oracle Database</p>
  
  <p>I need to write a select statement across two tables</p>
  
  <p><strong>Accounts &amp; Master</strong></p>
  
  <p>From the Accounts table, I need to select the <code>Account_Id, Account_Number, Bank_Id, and External_Code</code></p>
  
  <p>From the Master table, i need to select the <code>Account_String</code>.</p>
  
  <p>The Master's Account_String field matches the Account's Extenal_Code field</p>
  
  <p>thanx</p>