Skip to content

Instantly share code, notes, and snippets.

@parzibyte

parzibyte/consulta.sql

Created September 5, 2019 22:19
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/35bc9b0d5ed5eed5f362531426f3cc53 to your computer and use it in GitHub Desktop.
Save parzibyte/35bc9b0d5ed5eed5f362531426f3cc53 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;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment