Natural Join

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

Hi,

There is no Natural Join available in Sql Server.