Examples for joining with 2 columns

Question

Examples for joining with 2 columns

Closed this issue 6 years ago · 5 comments

How do I create a Join query that uses more than 1 column?

Answer 1 · 2018-05-14T19:30:20.000Z

Could you give me an example with a simple query ?
I'm not familiar with this type of query and besides using logical comparaisons (AND & OR) I don't find more examples relevant (or maybe that's it...)

Thank you.

Answer 2 · 2018-05-14T20:38:10.000Z

I'm trying to build a query with an AND operator

select * from t1 left join t2 on t1.a = t2.a AND t1.b = t2.b

Answer 3 · 2018-05-14T20:43:44.000Z

Perfect 🙂
I should be able to start writing an implementation soon.

Answer 4 · 2018-05-25T07:31:15.000Z

@fi0 Don't have much time at this moment, but I don't worry I won't forget this :)

Answer 5 · 2018-05-28T12:23:26.000Z

Does 6de1fa7 solves your issue ?