I'm joining JOB to AL_ALA_DATA. I want everyone's job data, even if they do not have an entry in AL_ALA_DATA. However, when I add AL_ALA_DATA and link it to JOB, I lose the unmatched records, even though I have checked "show unmatched records" for both file number and paygroup links from JOB to AL_ALA_DATA. Is this because there are two key fields in AL_ALA_DATA? , or because AL_ALA_DATA is also effective-dated? Both? Any ideas?
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.