4 ms·
See “natural join”, which already exists in SQL; I use it all the time.
by atemerev 2y ago
See “natural join”, which already exists in SQL; I use it all the time.
- doctor_eval 2y agoYeah I thought natural join was the same, but I keep forgetting to use it!
- ghusbands 2y agoNatural joins are terrible in that they match on any equal column names. Let's hope you don't have employees with names and departments with names. In any case, even with natural join syntax, you end up with queries longer than those in the article.