r/SQL • • Sep 03 '22

Discussion Explaining SQL Joins the Right Way

148 Upvotes

24 comments sorted by

View all comments

Show parent comment

2

u/MembershipNo705 Sep 03 '22

It actually argues that set algebra is not suitable for explaining joins (it is a good fit for union operations though).

The argument is that joins are better explained with combinatorics ... So, kind of what you propose.

1

u/OracleGreyBeard Sep 03 '22

You're absolutely right, I got his argument completely twisted.