Select ct_dia.id,tb_dia_confighorario.hora_inicio,tb_dia_confighorario.hora_fin from tb_dia_confighorario inner join tb_config_area_comun on tb_dia_confighorario.idConfigHorario=tb_config_area_comun.id Max(case when id = 7 then CONCAT(hora_inicio," - ",hora_fin) else 0 end) Domingo from Max(case when id = 6 then CONCAT(hora_inicio," - ",hora_fin) else 0 end) Sabado, Max(case when id = 5 then CONCAT(hora_inicio," - ",hora_fin) else 0 end) Viernes, Max(case when id = 4 then CONCAT(hora_inicio," - ",hora_fin) else 0 end) Jueves, Max(case when id = 3 then CONCAT(hora_inicio," - ",hora_fin) else 0 end) Miercoles, Max(case when id = 2 then CONCAT(hora_inicio," - ",hora_fin) else 0 end) Martes, Select max(case when id = 1 then CONCAT(hora_inicio," - ",hora_fin) else 0 end) Lunes,
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |