title: Joining on multiple tables in teradata
body: <p>Please help me through this</p>
  
  <pre><code>sel a.col1,a.co2,a.col3,.........b.col1,b.col2..,c.col1,c.col2
  from table1 as a inner join table2 as b on a.col1 =b.col1
  inner join table3 as c on a.col1 = b.col1
  where col1 = xxxxx;
  </code></pre>
  
  <p>Now i need join one more table table4. As table4 dont have col1 as primary index in it I need to join this to another table which has Primary key.</p>
  
  <p>The below is the different query which i need inculde this in to the above sel statement.</p>
  
  <pre><code>Sel xx.col1,yy.aaa,yy.bbb,zz.ccc,zz.ddd,zz.eee
  from tablea as xx, tableb as yy, table4 as zz
  where xx.col1 = yy.bbb and yy.aaa = zz.ccc
  </code></pre>
  
  <p>Primary indexs :</p>
  
  <ul>
  <li>col1 for table1,table2,table3,tablexx</li>
  <li>aaa for tableb</li>
  <li>ccc for table4</li>
  </ul>
  
  <p>Thanks in advance</p>