I'll give it a try and let you know.

Thanks

*************************

I tried it but had to modify your solution just slightly to return only the records where all subs were closed. To...

Sorry for the delay in responding.

Thanks for your help and suggestions, here's the query I ended up:

SELECT 

  s.Key

 FROM Sub s inner join Main m on m.key = s.key

 WHERE  s.key IN

    (Select Count(*) as...

Ninja,

Althought your solution is close it still does not quit answe rthe question. Using your method it will return the key from the main table if only one of the...