Matching Fields in Query

J

JLD

I have a query from threee tables. The tables are...

dbo_Property
dbo_Improvement
dbo_ImpSegment

I have joined and selected the fields from each table as needed. Now I have
a query that lists for me

From dbo_Property -- P_QuickRefID, P_Year

From dbo_Improvement -- I_Year

From dbo_ImpSegment -- IS_SegType, IS_SegClass, IS_Year

Now in the query results I have a property listed with many IS_SegType(s)
and a single IS_SegClass for each segment in each property.

All of this is correct.

Now my question, the SegClass should be the same for every different SegType
in a given property. How can a run a query that would return only those
SegClasses that are not the same for a SegType.

Example. I have a property with many segments (downstairs, upstairs, garage)
but there is only one class for a given property. So the class for the
downstairs, upstairs and all segments) should be the same. I have over
650,000 records and it would take forever to manually filter.

I know this is legnthy but THANKS!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top