0
Good afternoon friends,
I used the script below:
SELECT id_docent
, STRING_AGG(distinct no_municipio, ' / ') AS "Municipios"
FROM
public tb_uf
INNER JOIN
public.ts_docent
ON (tb_uf.co_uf = ts_docente.co_uf) AND (tb_uf.co_municipio = ts_docente.co_municipio)
GROUP BY id_docente
That gave me the result:
I would like to know if there is a command that tells me which dependency on municipalities, so:
Thanks for your attention.
Explain where the "depedência would come from".
– Motta
Dependency is whether it belongs to the State Network or Municipal or Federal or Private; and the command is in ts_docente
– Cintia Costa
A column ? Tried to concretely "no_municipio" ?
– Motta