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?

Artamiel•5/28/24, 4:38 PM

can you share the full snippet ?

I try to replicate on my machine but it working just fine