I have a query that gives me the results I want using a join type 3 (unmatched records with primary file), and I want to create a join logical file that will give the same results.
Basically, both files contain order data. I want to join on order number and only include the records from FILE A that do NOT have matching order number in FILE B. Is this even possible using a join logical file.
Basically, both files contain order data. I want to join on order number and only include the records from FILE A that do NOT have matching order number in FILE B. Is this even possible using a join logical file.
Comment