Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

See “natural join”, which already exists in SQL; I use it all the time.


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!




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: