CREATE VIEW view_red_cross_docs
    AS SELECT <code here>

CREATE VIEW view_pro_bono_docs
    AS SELECT <code here>

SELECT <stuff> FROM <joined views>