Skip to content

Instantly share code, notes, and snippets.

@valdiney

valdiney/sql

Created January 11, 2016 02:39
Show Gist options
  • Save valdiney/160e3a3ce411414e229f to your computer and use it in GitHub Desktop.
Save valdiney/160e3a3ce411414e229f to your computer and use it in GitHub Desktop.
Download ZIP
Relação sistemas Wifiaki
Raw
sql
SELECT radcheck.id, radcheck.id,
radcheck.username,
xvisitante.idvisitante
FROM radcheck
INNER JOIN xvisitante ON xvisitante.idradcheck = radcheck.id AND xvisitante.idvisitante
INNER JOIN xvisitante_equipamento ON xvisitante_equipamento.idvisitante = xvisitante.idvisitante
WHERE mac = '$(mac)'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment