select a.agent
,c.child
from child c
,agent_child ac
,agent a
where a.id = ac.id_agent -- So only ID's which are in agent_child
returned
and c.id = ac.id_child
ummo14 wrote:
>
> 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
Received on Mon Mar 13 2000 - 00:00:00 CST
