SQL Query

Try

select building_id,
building_name,
sum(unit_capacity) sum_unit_capacity,
sum(used_spaces) sum_used_spaces
from building_master a,
building_units b
where a.building_id=b.building_id;

---

Many Thanks & Best Regards, Hua Min