Sum based on related values in separate tables

I have two tables (sheets) in a single workbook: * Table 1: Name, Amount * Table 2: Name, Yes-No I want to (sum all of the Amounts) in Table 1 where (Table 1 and Table 2's name are the same) and (Table 2's corresponding Yes-No is Yes). In a relational database, this is trivial, but how do I do it with Apple Numbers?