How can I convert QUERY to TYPEORM functions

Asked

Viewed 7 times

-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?
No answers

Browser other questions tagged

You are not signed in. Login or sign up in order to post.