Get record counts from table - must be easy! 1

[addy]

OK

I have two tables, call then T1 and T2.

T1 has the following fields:

DossNo
DossRmk
DossPg

T2 has the following fields:

DossNo

In T1, DossNo is repeated for differing values of DossRmk and DossPg.

In T2 there are unique Values of DossNo, each of which appears in T1 - but does not contain all values of DossNo from T1.

What I need is a count of how many records there are in T1 for each value of DossNo whcih appears in T2.

I'm just having a brain craze day today and am not sure where to start.

Any ideas?

Thanks.

 

[PHV]

Something like this (SQL code) ?
SELECT T1.DossNo, COUNT(T2.DossNo)
FROM T1 LEFT JOIN T2 ON T1.DossNo = T2.DossNo
GROUP BY T1.DossNo

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[addy]

Thanks PHV - have yet another star!