Project filtering query…..

SELECT p.begin_year, (p.end_year+MAX(a.duration)) as end_year, p.uid

FROM budget_centers c, projects p, appropriations a

WHERE c.project_id = p.uid AND c.appropriation = a.type

GROUP BY p.uid