comparing results

[Anat Peleg]

We would like to only display some of the results of a query-- an example of the database is below. We display different drawing numbers each with a particular "status." If any drawing has a status of "H", we do not want to display any of the entries with that drawing number.

There are multiple copies of some drawings, however it isn't consistant (2 of some, 3 of some, 1 of some etc.)

Also there wlil always be a different number of query results (some days 2 drawings, some days 3, etc).

Any ideas how to execute this?
Thanks!


Ex.

Draw No Status
111 M
111 H
222 M
222 AH
222 M
333 H

[Rabbit]

Use a subquery that returns those drawing numbers with a status of H and use it to filter them out.