Select user login

getLogin.sql

--PEGA LOGIN DE ALUNO
SELECT(
	SELECT w.miolousername
	FROM acdcontract z
	INNER JOIN ONLY basphysicalpersonstudent w
	USING (personid)
	WHERE z.contractid = x.contractid)
	AS login
	FROM acdenroll x
	WHERE x.groupid = (
		SELECT max(groupid)
		FROM acdgroup y
		WHERE y.isclosed = true);


--PEGA LOGIN DE PROFESSOR
SELECT DISTINCT miolousername
FROM basperson
WHERE personid = (
	SELECT professorid
	FROM acdscheduleprofessor
	WHERE scheduleid = (
		SELECT max(scheduleid)
		FROM acdscheduleprofessor));