8 ms·

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 i

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.

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