Creating a few views might help you to get your head around the queries...

A database view is a sort of virtual table. You create it with a SELECT statement and then access it like a regular table.

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>
[download]

email: mandog