Hello Fellow Monarch End-Users,
I was wondering if there is a way to do a join where there are two keys and the first key has to match but the second key can't match? For this example, I want to show the rows where the member number matches but the FSR doesn't. So half negative join and half standard join. Has anyone created such a join combination and if so how would you recommend to accomplish this. Thank you.
------------------------------
Jon Dix
Research Analyst
Founders Federal Credit Union
Lancaster SC
(803) 289-5277
------------------------------