Advertisement
Guest User

Untitled

a guest
Sep 17th, 2019
130
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.30 KB | None | 0 0
  1. select turnos.numero, profesionales.nombre from turnos
  2. inner join profesionales
  3. on turnos.id_profesional = profesionales.id
  4. and turnos.id_profesional is not null
  5. and turnos.estado = 'ESPERANDO'
  6. and turnos.fecha = ?
  7. group by profesionales.id, turnos.numero, profesionales.nombre, hora
  8. order by hora asc
  9. limit 5
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement