-2
TABLE subjects id, course_id, Subject, subject_name, created_at
TABLE Ourses id, source, name, info, created_at
I have this function that searches the following fields
.query(`SELECT subjects.id, subjects.subject, subjects.subject_name, courses.name
FROM subjects
INNER JOIN courses ON subjects.course_id = courses.id;`);```
RETORNA ASSIM:
```{
id: "017ab1c8-4243-4c89-827f-49d475e40564",
subject: "4833",
subject_name: "MAT.BASICA PARA CIENC.SOC.APLICADAS",
name: "Ciências Econômicas"
}```
Como poderia ter essa query com sintaxe do TYPEORM?