Sunday, November 9, 2008

Natural Joins - Still not in MS SQL Server

One of the coolest join options in Oracle is the Natural Join. Provided that the tables' columns were named such that the column name indicated which columns in two or more tables should be used for a join, it reduced the effort in writing SQL queries.