How to include filters when making joins?

Question

mahmoudzeyada opened this issue 3 years ago · 2 comments

how to make a filter when making joins like this ?

SELECT * From TABLE_A INNER JOIN TABLE_B ON TABLE_A.id = TABLE_B.id AND TABLE_A.FLAG = true

Answer 1 · 2022-06-09T19:30:00.000Z

Any update ?

Answer 2 · 2024-05-13T10:24:09.000Z

Looking for the same thing.