I have several tables having the same fields and want to retrieve a field from all these tables. The select from one table looks like this:

SELECT field1, count(field1) AS count FROM dbtable1 GROUP BY field1 ORDER BY count DESC

now I want something like:

SELECT field1, count(field1) AS count FROM dbtable1,dbtable2,dbtable3,...,dbtableN GROUP BY field1 ORDER BY count DESC

How can I obtain this?