sql server, database

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?
Who is Participating?
Ephraim WangoyaConnect With a Mentor Commented:

select *
from A
inner join B on A.id = B.id
left join C on C.id = B.id
SharathData EngineerCommented:

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

Open in new window

HainKurtSr. System AnalystCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.