SQL join with related counts

[Tim Davis]

Hi,
    If anyone can help with this I'd really appreciate it.
I'm trying to list all rows of a table, with the quantities of its 
child table records. Here's an example of what I've tried, which 
crashes the server but not the app. (I'm using VServer and V4RB.)

Select Parent.Field1, Parent.Field2, Count(Child1.ID), 
Count(Child2.ID), Count(Child3.ID)
 From Parent, Child1, Child2, Child3
Order By Parent.Field1

Thanks,
Tim Davis