MMEMBER EXCEPTION JOIN GPLANMAS ON
MMEMBER.PLNCD = GPLANMAS.PLNCD
This is a query used in showcase tool.
It is looking for members who are
noted in the member file with an invalid plan code. The current query
produces 18 members with either invalid plan codes or blank plan codes. How can I achieve this in FM using inner join between these two table? According to me the package published has inner join between MMEMBER AND GPLANMAS tables. I will really appreciate the help.
Thanks a lot
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!