title: Join multiple columns - with single query
body: <p>I am looking to join two table. One table has an id and other table has id and its corresponding value. I am using 4 joins to get value for 4 columns. COST of the query is too high. Is there a way to reduce the COST ?</p>
  
  <p>sample code.</p>
  
  <pre><code>select b.empname, c.deptname, d.supervisorname 
  from idtable A, lookuptable B,lookuptable C,lookuptable D
  where b.lookuptable =a.empid  
  and c.lookuptable=a.empdeptid 
  and d.lookuptable = a.empsupervisorid;
  </code></pre>