Natural join in SQL Server
Is there any support for natural joins in recent Microsoft SQL Server editions? Or is there a good alternative for making SQL Server work out the predicates that would have been in the
ON clauses based on the referential integrity?
3 Solutions collect form web for “Natural join in SQL Server”
No, and thank the lucky stars
I can’t believe that you’d want the engine to guess the JOIN for you
- SQL Server – lack of NATURAL JOIN / x JOIN y USING(field)
- is NATURAL JOIN any better than SELECT FROM WHERE in terms of performance ?
Edit, to explain why
- The JOIN (whether USING or ON) is clear and explicit
- I should be able to name my columns for the entity stored in the table, without worrying about what a column is called in another table, without NATURAL JOIN side effects
I wouldn’t expect to see it any time soon. A Connect suggestion from 2006 has very little info other than:
Thanks for your feedback. We will look into your request for one of the upcoming releases.
And has only received ~30 upvotes
MS SQL does not support natural join, neither join using (). You have to explicitly write down all your attributes used in the join.
datamodel changes, you have to change all “natural join” written by hand and make sure your join condition is ok again.