How do I JOIN one table if the column is 1 and if not then JOIN another table?

Question

SQL

Attach different tables depending on the column that represents the record type.

Answer 1

For example like this:

select * from main join join1 on  join1.id = main.id and main.join_table = 1
union all
select * from main join join2 on  join2.id = main.id and main.join_table = 2;

SQL fiddle