General information
Category:
Coding, syntax & commands
Title:
Sql Select count of Child Keys
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only