Aqui os códigos para usar em seu TOTVS RM, conforme explicação no vídeo, em nosso canal de Youtube.
SELECT
*
FROM
SCONTRATO C
LEFT JOIN
SPARCELA P (NOLOCK)
ON C.RA = P.RA
AND C.CODCONTRATO = P.CODCONTRATO
AND C.CODCOLIGADA = P.CODCOLIGADA
AND C.IDPERLET = P.IDPERLET
LEFT JOIN
SLAN SL (NOLOCK)
ON P.CODCOLIGADA = SL.CODCOLIGADA
AND P.IDPARCELA = SL.IDPARCELA
LEFT JOIN
FLAN F
ON SL.IDLAN = F.IDLAN
AND SL.CODCOLIGADA = F.CODCOLIGADA
LEFT JOIN
SBOLSA CB (NOLOCK)
ON CB.CODCOLIGADA = F.CODCOLIGADA
AND CB.CODCFO = F.CODCFO
INNER JOIN
GCOLIGADA CO (NOLOCK)
ON CO.CODCOLIGADA = C.CODCOLIGADA
INNER JOIN
GFILIAL FI (NOLOCK)
ON FI.CODCOLIGADA = C.CODCOLIGADA
AND FI.CODFILIAL = C.CODFILIAL
LEFT JOIN
FCFO CF (NOLOCK)
ON CF.CODCOLIGADA = F.CODCOLCFO
AND CF.CODCFO = F.CODCFO
LEFT JOIN
FTDO TD (NOLOCK)
ON TD.CODCOLIGADA = F.CODCOLIGADA
AND TD.CODTDO = F.CODTDO
LEFT JOIN
SSERVICO(NOLOCK)
ON SSERVICO.CODSERVICO = P.CODSERVICO
AND SSERVICO.CODCOLIGADA = P.CODCOLIGADA
LEFT JOIN
STIPOCURSO(NOLOCK)
ON STIPOCURSO.CODTIPOCURSO = C.CODTIPOCURSO
AND STIPOCURSO.CODCOLIGADA = C.CODCOLIGADA
LEFT JOIN
SALUNO(NOLOCK)
ON SALUNO.RA = C.RA
AND SALUNO.CODCOLIGADA = C.CODCOLIGADA
LEFT JOIN
PPESSOA(NOLOCK)
ON PPESSOA.CODIGO = SALUNO.CODPESSOA
LEFT JOIN
SMATRICPL M (NOLOCK)
ON M.CODCOLIGADA = C.CODCOLIGADA
AND M.IDPERLET = C.IDPERLET
AND M.IDHABILITACAOFILIAL = C.IDHABILITACAOFILIAL
AND M.RA = C.RA
LEFT JOIN
STIPOMATRICULA(NOLOCK)
ON STIPOMATRICULA.CODCOLIGADA = M.CODCOLIGADA
AND STIPOMATRICULA.CODTIPOMAT = M.CODTIPOMAT
LEFT JOIN
SHABILITACAOALUNO(NOLOCK)
ON SHABILITACAOALUNO.CODCOLIGADA = M.CODCOLIGADA
AND SHABILITACAOALUNO.IDHABILITACAOFILIAL = M.IDHABILITACAOFILIAL
AND SHABILITACAOALUNO.RA = M.RA
LEFT JOIN
SHABILITACAOFILIAL SH (NOLOCK)
ON SH.CODCOLIGADA = SHABILITACAOALUNO.CODCOLIGADA
AND SH.IDHABILITACAOFILIAL = SHABILITACAOALUNO.IDHABILITACAOFILIAL
LEFT JOIN
SCURSO CU (NOLOCK)
ON CU.CODCOLIGADA = SH.CODCOLIGADA
AND CU.CODCURSO = SH.CODCURSO
LEFT JOIN
SPLETIVO PL (NOLOCK)
ON PL.CODCOLIGADA = M.CODCOLIGADA
AND PL.IDPERLET = M.IDPERLET
LEFT JOIN
SSTATUS SS (NOLOCK)
ON SS.CODSTATUS = M.CODSTATUS
AND SS.CODCOLIGADA = M.CODCOLIGADA
LEFT JOIN
FBOLETO(NOLOCK)
ON FBOLETO.CODCOLIGADA = F.CODCOLIGADA
AND FBOLETO.IDBOLETO = F.IDBOLETO