troubleshooting Question

Access SQL Query Question

Avatar of Jonathan Mori
Jonathan MoriFlag for United States of America asked on
SQL
9 Comments2 Solutions222 ViewsLast Modified:
I have a large table that has a Column of numbers ranging from 0001 - 0008 and they represent a frequency of how often a payment is due for a  property owner, such as Annually, Semiannually, etc.

I  need a query that filters it out this way. It should only display the 0001 if its all the property has, but if it has more than just 0001 then it has to display all the records except for the one that has 0001 frequency code.

Property    Frequency
__________________
Property1  0002
property1  0004
property1  0005
property1  0001

property2 0001

property3 0001
property3 0002
property3 0004
property3 0008

property4 0001
property4 0002
property4 0003

property5 0001

It's a little confusing I know, that's why i'm having trouble with it!
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 2 Answers and 9 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 9 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros