Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Count records in multiple tables

Status
Not open for further replies.
thorny00

thorny00

Programmer
Feb 20, 2003
122
US
I have the following that gives me all the tables that with FOO in the table name. Now I want to list each table that has FOO in the table name and the count of records in each of those tables.
I.E.
TableName Count
FOO1 1000
FOO2 50,000
FOO3 100,000
F004 90
I know I can do a select count(*) from FOO1 and so forth, but I would like to list all tables and counts together.

Thanks in advance for you time and help, I greatly appreciate it.
 
Sort by date Sort by votes
Use a Union all statement

Questions about posting. See faq183-874
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

SashaBuilder3
  • Locked
  • Question
select a single row based on conditions in multiple rows 1
Replies
3
Views
874
SashaBuilder3
SashaBuilder3
peac3
  • Locked
  • Question
Consolidate multiple rows into single row 1
Replies
4
Views
1K
Chris Miller
Chris Miller
peac3
  • Locked
  • Question
split one row into multiple rows... help pls 2
Replies
12
Views
1K
Chris Miller
Chris Miller
BobThornton
  • Locked
  • Question
Drop a table based on the count of records in another table
Replies
13
Views
727
Chris Miller
Chris Miller
WomanPro
  • Locked
  • Question
Insert into query adds records to unreadable format, how do I change that? 1
Replies
5
Views
594
Chris Miller
Chris Miller

Part and Inventory Search

Sponsor

Back
Top