1 reply

Chain multiple joins

I have this query

db.select().from(table1).leftjoin(table2, ...).leftjoin(table3, ...)

db.select().from(table1).leftjoin(table2, ...).leftjoin(table3, ...)

However I'm getting type error on second leftjoin that

leftjoin does not exists on type ...

leftjoin does not exists on type ...

. But if I run the same query on Drizzle Studio. It works as expected.

Any reasons why it spits a type error?

Chain multiple joins - Drizzle Team