query sql problem

i have 3 tables:
I have 3 tables
table1:Agent

   column: id agent
   column: agent name

table2:Agent_child

   column: id agent
   column: id child
table3:Child

   column: id child
   column: name child

If a Sql guru could help me It will be great for me. I want to select the name of the agents which have at least one child (if it's possible in displaying the number of child beside the name of the agents)

• Sent from AltaVista http://www.altavista.com Where you can also find related Web Pages, Images, Audios, Videos, News, and Shopping. Smart is Beautiful