title: SQL Server - Combining OUTER and INNER joins
body: <p>I have 3 tables and I have to inner join Table A with Table B but a left outer between Table A and Table C. </p>
  
  <p>Can I combine outer and inner join in the same query? I can nest queries and attain the desired result but I am unable to do both the joins in the same query. It appears that in other SQL languages, the order of joining is important. Is this the case in SQL Server as well?</p>
  
  <hr>
  
  <p>Ok, here's the scenario.</p>
  
  <p>Consider 3 tables. Table A, Table F, Table D.</p>
  
  <p>I will need the recordset to contain all rows in D irrespective of whether it exists in F (after it's inner joined with A). So, a outer join comes to mind. What I would need is:</p>
  
  <ol>
  <li>First do a inner join between A and F to get a set (this may be a null set)</li>
  <li>Then do a outer join with the recordset in (1) with D</li>
  </ol>