Expressing some queries without employing JOIN or OUTER JOIN
Left outer join will be:

select s.a, s.b, (select c from t where s.b =t.b) as outercol
from s


Full outer join will be:

select s.a, s.b, (select c from t where s.b =t.b) as outercol
from s
union all
select null, b, c from t
where b not in (select b from s)