title: Fetching other rows of table when performing inner join over multiple fields (oracle query)
body: <pre><code>select pmt.col1,table2.col1,table2.col3,table3.col1,table3.col1 
  from   table2 inner join (select distinct 
  col1,col2 from table1) pmt on 
  table2.col1=pmt.col1 inner join table3 on 
  table3.col1=table1.col2 where table2.col2 is null;    
  </code></pre>
  
  <p>Is there any way I can select pmt.col3(which is other column of table1) in this very query only.</p>
  
  <p>Thanks very much</p>