<div>
<br />
try this.
<pre><code id="code-20-36497771-1">select *
  from A
  join B on A.id = B.id -- add your other conditions
  left join C on A.id = C.id</code></pre>
</div>



try this.

select *
  from A
  join B on A.id = B.id -- add your other conditions
  left join C on A.id = C.id

<div>
maybe this<br />
<br />
select * from <br />
(<br />
select a.*, b.some other columns from a inner join b on a.id=b.id and ...<br />
) x left join c on x.id=c.id
</div>


maybe this

select * from
(
select a.*, b.some other columns from a inner join b on a.id=b.id and ...
) x left join c on x.id=c.id

<div>
<div class="content wysiwyg-content">
I need to join 3 tables A, B, C &nbsp;inner join A and B on ID and some other conditions. Then the result should be joined with C on the same id . but with C its a left outer join on the id. any suggestions?
</div>
</div>


I need to join 3 tables A, B, C  inner join A and B on ID and some other conditions. Then the result should be joined with C on the same id . but with C its a left outer join on the id. any suggestions?

sql server, database

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.