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