Counting from several tables

From: Keith C. Jakobs, MCP <elohir_at_hotmail.com>
Date: Mon, 03 Jun 2002 23:54:35 GMT
Message-ID: <%kTK8.16136$153.271725735@newssvr14.news.prodigy.com>

Greetings:

I am trying to make a SQL script that will tell me the the number of records across several tables, listed by date.

I would like my row data to show a range of dates, and the count of records for each table as my columns, though I will transpose row and columns if necessary (Can I use row data for column headings)?

I know how to format my date comparisons, and I can do this script perfectly for one table using the script below, but I have no idea how to make one script, that will tally the count of all tables, in one output table.

SELECT TO_CHAR(logdate, 'MMDDYY') AS "Date", count(*) AS "Table1" FROM table1
GROUP BY "Date";

I need the counts of Table2, Table3, etc. to also show up in this table.

Can anyone help?

Thanks in advance,

Keith C. Jakobs, MCP
elohir_at_hotmail.com Received on Mon Jun 03 2002 - 18:54:35 CDT