SQL join different tables depending on row information
Asked 2010-03-13T23:17:55.667
11
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?