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!
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!