Hacker News new | ask | show | jobs
by atemerev 770 days ago
See “natural join”, which already exists in SQL; I use it all the time.
2 comments

Natural 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.

Yeah I thought natural join was the same, but I keep forgetting to use it!