select count(*) from tableA INNER JOIN tableB ON (tableA.tableAkey = tableB.tableBkey) select count(*) from tableA, tableB WHERE tableA.tableAkey = tableB.tableBkey