If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

The correst resukt

Here is a revised in working order query!

select Mike.c1 as name, count(Mike.c1) as MikeCount,
T1.Tcount as BillCount
from Mike
join
(select Bill.c1 as Bills,
count(Bill.c1) as Tcount
from Bill
group by Bill.c1) as T1
on Mike.c1 = T1.Bills
group by Mike.c1

Enjoy.

Knowledge is that which can be shown to be the case, and Intelligence is the method one uses to deploy the demonstration of what is the case, everything else is Information.