RE: Sql muddle

SELECT *
FROM TABLE a
WHERE EXISTS( SELECT *
FROM TABLE b
WHERE a.ID = b.parentID
AND b.AGE > 20 )
AND EXISTS( SELECT *
FROM TABLE c
WHERE a.ID = c.parentID
AND c.AGE < 20 )

What about if a client has children who are 20?

Paul Morgan

Principal Programmer Analyst
IT Supply Chain/Replenishment

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Dave
Sent: Monday, April 02, 2012 11:56 AM
To: Midrange Systems Technical Discussion
Subject: Sql muddle

Hi,

I'm getting in a real twist with this one :

Given a table with a client and his children with their dates of birth, I
want to select those clients having at least one child aged over 20 AND at
least one child under 20.

The answer would be very much appreciated.