Skip to content

Instantly share code, notes, and snippets.

@alphanetEX
Created July 20, 2023 20:41
Show Gist options
  • Save alphanetEX/6717345c63d3cc1baff14b453d833c7a to your computer and use it in GitHub Desktop.
Save alphanetEX/6717345c63d3cc1baff14b453d833c7a to your computer and use it in GitHub Desktop.
partial
SELECT CONCAT(usr.name,' ', usr.lastname) AS usuario
FROM users usr WHERE usr.user_id IN (SELECT usr.user_id from users usr
INNER JOIN user_types ON user_types.user_type_id = usr.user_id);
SELECT
CONCAT(usr.name,' ', usr.lastname) AS nombre,
courses.curseTitle,
cert.token_cert AS token
FROM certifications cert
INNER JOIN inscriptions ON inscriptions.inscription_id = cert.inscription_id
INNER JOIN cursadas crs ON crs.cursada_id = inscriptions.cursada_id
INNER JOIN courses ON courses.course_id = crs.cursada_id
INNER JOIN users usr ON usr.user_id = inscriptions.user_id;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment