Hacker News new | ask | show | jobs
by youerbt 881 days ago
I feel like natural joins simplify writing queries, but not exactly reading them (especially if you are not familiar with the database). IMO a good compromise is the USING clause, which acts like a natural join, but columns have to be named explicitly.
2 comments

Maybe some SQL server should require a token like “USING_WILD_GUESS” when doing a natural join :)
The problem with USING is that it isn't supported everywhere.