title: Optimize joins from multiple tables
body: <p>How can I optimize <strong>Performance</strong> of the below mentioned query when the table structure is as shown in the pic below</p>
  
  <p><a href="http://i.stack.imgur.com/ay3FH.png" rel="nofollow">Pic Showing The Table Structure</a></p>
  
  <pre><code>select CounterID, OutletTitle, CounterTitle
  from(
      select OutletID, Text as OutletTitle 
      from Outlets as q1
      inner join 
      TranslationTexts as tt 
      on q1.TitleID=tt.TranslationID
      where tt.Locale='ar-SA' and q1.CompanyID=311 and q1.OutletID=8 --Locale &amp; CompanyID &amp; OutletID
      ) as O    
  inner join    
  (
      select CounterID, Text as CounterTitle, OutletID
      from Counters as q1
      inner join 
      TranslationTexts as tt 
      on q1.TitleID=tt.TranslationID
      where tt.Locale='ar-SA' and q1.OutletID=8 --Locale &amp; OutletID   
  ) as C
  on O.OutletID=C.OutletID
  </code></pre>