By default outer join is bidirectional ? or only left join or only right join?
outer join is syntactically the same as left join or left outer join. Some (most?) rdbmss support a full outer join syntax which allows missing rows on both sides of the join.
outer join
left join
left outer join
full outer join