SQL join different tables depending on row information

Posted by Xster on Stack Overflow See other posts from Stack Overflow or by Xster
Published on 2010-03-13T23:17:55Z Indexed on 2010/03/13 23:25 UTC
Read the original article Hit count: 333

Filed under:
|
|

Hi, I think this question hasn't be asked yet.

Suppose I have table A with a field that can be either 1 or 2 How do I select such that for each row in table A, if the field is 1, join the select with table B and if the field is 2, join the select with table C?

© Stack Overflow or respective owner

Related posts about sql

Related posts about join