I have 2 files I am joining. The primary file is an employee master.
The secondary is a history file with the employees time punches. Using a type 1 join it works fine.
The user wants a change to the query to show the employees who did not punch in for a specific day as well, which would be a type 2 join. Running the query doesn't give the results I am expecting.
I do have a prompt for the user for the record select in the query definition where they change the desired date. The date exists in the secondary file.
Now when the user runs the qry, it still only returns matches to that date. It does not return any primary records that are not found with data for that date.
Is this because of the date selection?
Is there any way around this without havig to write a program?
This is on an AS/400 running V6R1M0