Here is one way:

SELECT P.people_code_id, G.giving_amount, G.fiscal_year
FROM People AS P
JOIN GivingSummary AS G
ON P.people_code_id = G.people_org_code_id
WHERE EXISTS (SELECT *
FROM GivingSummary AS G2
WHERE G2.people_org_code_id = G.people_org_code_id
AND G2.giving_amount >= 500
AND G2.fiscal_year <> '');


HTH,

Plamen Ratchev
http://www.SQLStudio.com