If you posted the table structures as well as the full SELECT statement including the JOIN and WHERE clauses, I'm sure you can get the result you are looking for, if not in one pass then as two consecutive queries. My guess is that you need to add some fields from t2 in the first result set and that an aggregation of the COUNT from the first result set will get you there in a second query.
>Is there something I could add to SELECT to get what I want?
>TIA Mark