By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,106 Members | 2,686 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,106 IT Pros & Developers. It's quick & easy.

comparing results

P: 1
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?


Draw No Status
111 M
111 H
222 M
222 AH
222 M
333 H
Jun 25 '12 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 10K+
P: 12,366
Use a subquery that returns those drawing numbers with a status of H and use it to filter them out.
Jun 25 '12 #2

Post your reply

Sign in to post your reply or Sign up for a free account.