To clarify, an INNER JOIN is equivalent to a SELECT from multiple tables with a WHERE clause, i.e. these are the same:
select count(*) from tableA
INNER JOIN tableB ON (tableA.tableAkey = tableB.tableBkey)
select count(*) from tableA, tableB
WHERE tableA.tableAkey = tableB.tableBkey