Hi

I am trying to count number so records in a group of tables. I need the
answer.db to include the name of the table and the number of records in
that table.

I use:

SELECT COUNT (*)
FROM "Table1.DB"
UNION SELECT COUNT (*)
FROM "Table2.DB"

what syntax do I need to include to get the tablename?

thanks
Dan

Titian wrote:

SELECT "table1" tablename, COUNT(*)
FROM "table1.db"
UNION ALL
SELECT "table2" tablename, COUNT (*)
FROM "Table2.DB"

etc. Obviously, if there are many tables, there are enumeration methods
that can be used to automate the generation of the string that will be the
SQL statement.

--
Larry DiGiovanni
Digico, Inc.
IT Consulting and Staffing Solutions
www.digicoinc.com
Check out www.thedbcommunity.com for Paradox resources.

Thanks for the quick response,

I knew the MS Access sql version, and that the Paradox would be
similar!

appreciate your help.

Dan

Larry DiGiovanni wrote: