select a.f1, a.f2, ...., b.f1, b.f2, ...
from tableA a, tableB b
where
a.key=b.key ... and .....