• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 370
  • Last Modified:

join 2 tables on differnt joins based on 2 different conditions

when you join 2 tables on differnt joins based on 2 different values, is it possible to consolidate the 2 queries into 1?

select * from a join b on a.id = b.id1 and b.indicator = 0
union
select * from a join b on a.id = b.id2 and b.indicator = 1
0
25112
Asked:
25112
2 Solutions
 
twolCommented:
select * from a inner join b
on (a.id = b.id1 and b.indicator = 0) or (a.id = b.id2 and b.indicator = 1 )
0
 
deightonprogCommented:
I believe the SQL you gave does exactly what you ask, so the answer is yes
0
 
25112Author Commented:
works..
0
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.

Join & Write a Comment

Featured Post

Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now