//SQL String
 SELECT DISTINCT dtd.id_disciplina, dis.nome_disciplina
 FROM 	iesc.tbl_docente_turma_disciplina dtd, iesc.tbl_disciplina dis
 WHERE 	dtd.id_ie = 1
 AND	  	dtd.id_curso in (320)
 AND	  	dtd.id_pessoa = 143928
 AND   	dtd.id_ie = dis.id_ie
 AND   	dtd.id_disciplina = dis.id_disciplina
 ORDER BY dis.nome_disciplina

//My Query
 const Table = Database.table('tbl_docente_turma_disciplina as dtd', 'tbl_disciplina as dis')

        return await Table
            .distinct('dtd.id_disciplina', 'dis.nome_disciplina')
            .whereIn('dtd.id_curso', [320])
            .where('dtd.id_ie', 1)
            .where('dtd.id_pessoa', 143928)
            .where('dtd.id_disciplina', 'dis.id_disciplina')
            .orderBy('dis.nome_disciplina')


 //Output error
 select distinct `dtd`.`id_disciplina`, `dis`.`nome_disciplina` from `tbl_docente_turma_disciplina` as `dtd` where `dtd`.`id_curso` in (320) and `dtd`.`id_ie` = 1 and `dtd`.`id_pessoa` = 143928 and `dtd`.`id_disciplina` = 'dis.id_disciplina' order by `dis`.`nome_disciplina` asc - ER_BAD_FIELD_ERROR: Unknown column 'dis.nome_disciplina' in 'field list'