Natural Join

Question

Hi Dudes Can any one tell how can i use natural join in sql server 2005

Jiteendra Sampathirao · Answer

hi natural joins are not available in Sql server 2005... refer For Sql joins Click Here hope it help you.......

Zoran Horvat · Answer

SQL Server does not support specific syntax for natural joins. Generally natural joins should not be used at the syntax level but only manually because they are very dangerous. I will give you an example: CREATE TABLE Position ( PositionID INT PRIMARY KEY IDENTITY(1 1) Name VARCHAR(100) ); CREATE TABLE Employee ( EmployeeID INT PRIMARY KEY IDENTITY(1 1) PositionID INT Name VARCHAR(100) ); Natural join in this case would join Name columns in Position and Employee tables as well but that would be wrong because those columns specify distinct properties of the position and employee in the database. Correct (manually formed) natural join would be: SELECT Position.PositionID Position.Name AS PositionName Employee.EmployeeID Employee.Name AS EmployeeName FROM Position INNER JOIN Employee ON Position.PositionID = Employee.EmployeeID; Personally I expect that SQL Server will never support NATURAL JOIN syntax. Zoran

Manish Dwivedi · Answer

Hi There is no Natural Join available in Sql Server.