Sample Header Ad - 728x90

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