eu fuçando aqui ficou assim:
SELECT meso.the_geom, meso.gid, meso.nome, estabest2007 + estabest2007_9_anos as estabest2007, estabfed2007 + estabfed2007_9_anos as estabfed2007, estabmun2007 + estabmun2007_9_anos as estabmun2007, estabpriv2007 + estabpriv2007_9_anos as estabpriv2007 FROM ( SELECT soc_estab_nfm_2007.mesoregiao, sum(soc_estab_nfm_2007.estab_fund_fed) AS estabfed2007, sum(soc_estab_nfm_2007.estab_fund_est) AS estabest2007, sum(soc_estab_nfm_2007.estab_fund_mun) AS estabmun2007, sum(soc_estab_nfm_2007.estab_fund_priv) AS estabpriv2007 FROM social.soc_estab_nfm_2007 GROUP BY soc_estab_nfm_2007.mesoregiao) estab2007, ( SELECT soc_estab_nfm_2007_9_anos.mesoregiao, sum(soc_estab_nfm_2007_9_anos.estab_fund_fed) AS estabfed2007_9_anos, sum(soc_estab_nfm_2007_9_anos.estab_fund_est) AS estabest2007_9_anos, sum(soc_estab_nfm_2007_9_anos.estab_fund_mun) AS estabmun2007_9_anos, sum(soc_estab_nfm_2007_9_anos.estab_fund_priv) AS estabpriv2007_9_anos FROM social.soc_estab_nfm_2007_9_anos GROUP BY soc_estab_nfm_2007_9_anos.mesoregiao) estab2007_9_anos, ( SELECT mesoregioes.the_geom, mesoregioes.gid, mesoregioes.nome FROM mesoregioes) meso WHERE estab2007.mesoregiao::text = estab2007_9_anos.mesoregiao::text AND estab2007.mesoregiao::text = meso.nome::text AND estab2007_9_anos.mesoregiao = meso.nome::text []´s _______________________________________________ pgbr-geral mailing list pgbr-geral@listas.postgresql.org.br https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral