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 .... But if I run the same query on Drizzle Studio. It works as expected. Any reasons why it spits a type error?

1 Reply

Artamiel•6mo ago

can you share the full snippet ? I try to replicate on my machine but it working just fine

Gaming

Programming

Chain multiple joins