in reply to Re: perl dbi select question
in thread perl dbi select question

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