AnsweredAssumed Answered

Self-Join Table Not Getting Expected Results

Question asked by Linda on Apr 26, 2016
Latest reply on Apr 27, 2016 by electon

I have created a self-join file to identify records where DateMailed does not equal VisitDate.  When I display the records from this self-join, I am seeing the same record over and over and the VisitDate and DateMailed match. This is my first time using a self-join.  Is there something else I need to do to get the self-join to only display records where the two dates in the same record don't match?  thanks, Linda

 

Outcomes