select * from tableA, tableB where column = column
equal join
select * from tableA join tableB on column = column;
left outer join
select * from tableA left outer join tableB on column = column;
right outer join
select * from tableA righ outer join tableB on column = column;
self join
select a1. * from tableA a1 join jableA a2 on a1.coulumn = a2.column;