field of one record to a field of a different record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to compare the term date of a given record of a consumer with the effect date of a different record of same consumer. if term date is 1 less than effect date then the consumer is not needed. How can a field from one record be compared to a field of a different record? I have tried running exists and not ins for sub queries and am gettng no where. Thanks.
 
Seeker,

This is pretty vague, can you give us an example of what your data looks
like and what you are hoping the output would look like?

Dale

seeker53 said:
I need to compare the term date of a given record of a consumer with the
Click to expand...
effect date of a different record of same consumer. if term date is 1 less
than effect date then the consumer is not needed. How can a field from one
record be compared to a field of a different record? I have tried running
exists and not ins for sub queries and am gettng no where. Thanks.
 
Back
Top