Do most real world join conditions involve no more than 2 columns?
0
votes
0
answers
24
views
In the database application I have worked on, all join conditions are binary, like
select * from A join B join C on A.id=B.id and B.orderno = C.orderno
Each condition, separated by "and", is a binary condition, that involves columns from 2 tables.
I know these conditions could involve variables from more than 2 tables, such as:
select * from A join B join C on A.x+B.x+C.x<10 and A.y+B.y+C.y<100
in the "real world" applications, are tertiary and more complex join conditions common?
Asked by larryliu
(1 rep)
Apr 4, 2022, 12:32 AM