Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT tbCodes.code, tbCodes.dni AS dni, nombre, apellidos, direccion, piso, numero, puerta, codigopostal, poblacion, provincia, movil, LOWER(email) AS email, fecha
- FROM tbCodes, tbParticipantes, tbProvincias
- WHERE tbParticipantes.idprovincia = tbProvincias.idprovincia AND
- tbParticipantes.dni = tbCodes.dni AND
- LENGTH(dni) > 0 AND
- tbCodes.dni NOT IN (SELECT dni FROM tbPremiados)
- ORDER BY dni, fecha ASC
Add Comment
Please, Sign In to add comment