How to use if else in Join?

Question

SQL

I have an apartments table , inside this publisher_type column, how can I make it so that if publisher_type is 0 then Join user_table, and when publisher_type is 1 then Join organization_table?

Answer 1

Like so?

select  foo from apartments a
left join user_table u on u.id=a.user_id AND a.publisher_type=0
left join organization_table  o on o.id=a.organization_id AND a.publisher_type=1

Answer 2

Heh. At one time I used the following life hack:
SELECT ..... WHERE ..... AND publisher_type= 0
UNION ALL -- it is important not UNION, but UNION ALL (google the difference)
SELECT ..... WHERE ..... AND publisher_type <> 0