SQL help

From: ummo14 <ummo14NOumSPAM_at_hotmail.com.invalid>
Date: 2000/03/13
Message-ID: <0047c5c4.fad4e447@usw-ex0110-075.remarq.com>#1/1

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

Received on Mon Mar 13 2000 - 00:00:00 CST