SELECT * FROM ((
	SELECT
	    broker_profile.usr_id as broker_id, brokerage_firm.firm_name,  
		building.building_id, building.bldg_type_id, building.hood_id, hood.hood_name, building.name, building.street, building.address, usr.first_name, usr.last_name, 
		broker_building_reviews.date_added, broker_building_reviews.about_building as bedrooms, broker_building_reviews.broker_id as price, 'BR' as type
		FROM broker_building_reviews,broker_profile,brokerage_firm,building,usr,hood
	WHERE
			building.hood_id = hood.hood_id AND
	        broker_building_reviews.building_id = building.building_id AND
	        broker_building_reviews.broker_id = broker_profile.usr_id AND
	        broker_profile.brokerage_id = brokerage_firm.brokerage_id AND
	        usr.usr_id = broker_profile.usr_id
	)
		UNION ALL
	(
	SELECT
		broker_profile.usr_id as broker_id, brokerage_firm.firm_name,  
		building.building_id, building.bldg_type_id, building.hood_id, hood.hood_name, building.name, building.street, building.address, usr.first_name, usr.last_name, 
		broker_apartment_reviews.date_added, bedroom.bedroom as bedrooms, broker_apartment_reviews.price as price, 'AR' as type
		FROM broker_apartment_reviews,broker_profile,brokerage_firm,building,bedroom,usr,hood
	WHERE
			building.hood_id = hood.hood_id AND
	        broker_apartment_reviews.building_id = building.building_id AND
	        broker_apartment_reviews.broker_id = broker_profile.usr_id AND
	        broker_profile.brokerage_id = brokerage_firm.brokerage_id AND
	        usr.usr_id = broker_profile.usr_id AND
	        broker_apartment_reviews.bedroom_id = bedroom.bedroom_id 
	)
	    UNION ALL
    (
    SELECT
    	broker_profile.usr_id as broker_id, brokerage_firm.firm_name,  
		building.building_id, building.bldg_type_id, building.hood_id, hood.hood_name, building.name, building.street, building.address, usr.first_name, usr.last_name, 
		broker_deals_desc.date_closed as date_added, bedroom.bedroom as bedrooms, broker_deals_desc.sales_price as price, 'BD' as type
    FROM 
    	broker_deals_desc, broker_profile, brokerage_firm, building, bedroom, usr, hood
	WHERE
			building.hood_id = hood.hood_id AND
	        broker_deals_desc.building_id = building.building_id AND
	        broker_deals_desc.broker_id = broker_profile.usr_id AND
	        broker_profile.brokerage_id = brokerage_firm.brokerage_id AND
	        usr.usr_id = broker_profile.usr_id AND
	        broker_deals_desc.bedroom_id = bedroom.bedroom_id 
	)
	    UNION ALL
    (    
    SELECT
    	broker_profile.usr_id as broker_id, brokerage_firm.firm_name,  
		building.building_id, building.bldg_type_id, building.hood_id, hood.hood_name, building.name, building.street, building.address, usr.first_name, usr.last_name, 
		usr_deals.accepted as date_added, NULL as bedrooms, usr_deals.price as price, 'CD' as type
    FROM 
    	usr_deals, broker_profile, brokerage_firm, building, usr, hood
	WHERE
		building.hood_id = hood.hood_id AND
        usr_deals.building_id = building.building_id AND
        usr_deals.agent_id = broker_profile.usr_id AND
        broker_profile.brokerage_id = brokerage_firm.brokerage_id AND
        usr.usr_id = broker_profile.usr_id
	)     	
)  A