The first part of your problem can be solved with:

SELECT * from TABLEA a, TABLEB b where a.ab1 = b.ab1

The second part may be solved using inner and outer joins.