Created
April 16, 2010 17:31
-
-
Save avelino/368700 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
select tb_visita.id_centro AS 'Nº do Centro', tb_cuidador.cuidador AS 'Nº do Cuidador', tb_visita.ds_responsavel AS 'Login', tb_visita.ds_inicias AS 'Iniciais', tb_visita.dt_visita_dd_v1_m1 AS 'Data' from tb_visita | |
inner join tb_cuidador on tb_cuidador.cuidador=tb_visita.id_paciente | |
inner join tb_centro on tb_centro.ncentro=tb_cuidador.centron | |
inner join tb_uc on tb_uc.ncentro=tb_centro.ncentro | |
GROUP BY tb_visita.ds_inicias ORDER BY tb_visita.id_centro, tb_visita.ds_inicias, tb_cuidador.cuidador |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment