I have two tables, one is a child of the other.
Is there one Sql Statement that will give me a count of the child records for each Primary Key
e.g.
Parent Table
A
B
C
--------------------------------
Child Table
A XX
A VVV
A GDS
B HH
B UYU
D aaaa
-----------------------------
Result would be
A 3
B 2
C 0
D 1

Tia
Gerard