Skip to content

Instantly share code, notes, and snippets.

@parzibyte

parzibyte/consulta.sql

Created September 5, 2019 22:21
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save parzibyte/45e567bc83b1e3cb4c91a8f2d09a647e to your computer and use it in GitHub Desktop.
Save parzibyte/45e567bc83b1e3cb4c91a8f2d09a647e to your computer and use it in GitHub Desktop.
Download ZIP
Raw
consulta.sql
select turnos.numero, profesionales.nombre from turnos
inner join profesionales
on turnos.id_profesional = profesionales.id
and turnos.id_profesional is not null
and turnos.estado = 'ATENDIENDO'
and turnos.fecha = ?
group by profesionales.id, turnos.numero, profesionales.nombre;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment