Thanks for the valuable information.

I checked the Query like this :

"SELECT * FROM dbo.Customers AS C

MIDDLE JOIN dbo.Employees E ON C.CustomerID = E.EmployeeID",so it's showing some error.If i try to join same field name in different tables,that time also i am getting some error.

Like : "SELECT * FROM dbo.Customers AS C

MIDDLE JOIN dbo.Employees E ON C.CustomerID = E.CustomerID "

Please provide me some usefull links to know more about MIDDLE JOIN.

Thanks & Regards

Sagesh.k 🙂