title: Natural join in SQL Server
body: <p>Is there any support for <a href="http://en.wikipedia.org/wiki/Join_(SQL)#Natural_join" rel="noreferrer">natural join</a>s 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 <code>ON</code> clauses based on the referential integrity?</p>