I should have given an example ..
select count(*) as record_count, date(column_name) as date_field, 'my_table' as table_name
union all
select count(*) as record_count, date(column_name) as date_field, 'my_table_2' as table_name
and end up with:
count | date | table_name
-------------------------------
5 | 2009-01-01 | table 1
10 | 2009-01-01 | table 2
I will try this. I got lost on your post before Ben offered the start of this version. But now I'll try this one. Probably tomorrow. I just want to say now - thank you guys for your attention to help me through these initial fires!
(I ordered some SQL books.)
-G