I have an existing report that pulls current information. The report pulls information of members who have requested a fee waiver for the current year. How can I make this pull only those who applied for the same waiver from last year and applied again for the same waiver this year?

Here is the SQL from the Crystal report as reference.

 

SELECT Name.ID, Name.CATEGORY, Name_All.BIRTH_YEAR,
        Activity.ACTIVITY_TYPE, Name.FIRST_NAME, Name.LAST_NAME, 

        Name.MEMBER_TYPE, Activity.DESCRIPTION, Name.COUNTRY,

        Activity.PRODUCT_CODE, Activity.TRANSACTION_DATE
FROM   (Name INNER JOIN Activity ON Name.ID=Activity.ID) INNER JOIN Name_All ON Name.ID=Name_All.ID

WHERE  Name.CATEGORY='85_1' AND Activity.ACTIVITY_TYPE='WAIVER'
        AND (Activity.PRODUCT_CODE='85_1 - Maternity Leave' OR Activity.PRODUCT_CODE='85_1 - Paternity Leave')
  AND Activity.TRANSACTION_DATE>='2011-05-26'

 ORDER BY Name.ID

 

I would really appreciate any assistance. I am not a programmer nor a developer.

 

Kind regards,
PeterG