select d.name, c.name, b.quantity, f.name 
	from master_corporations f, building_defs c, colonies d, master_building b
	where f.idnum = d.corp and b.colony = d.idnum and c.idnum = b.bnum;