Hi, I am currently going through the Tutorials on SQL Server Management Studio 2008 R2.
One of the samples instructs me to run the following code:
SELECT Mgr.EmployeeID AS MgrID, Mgr.LoginID AS Manager, Emp.EmployeeID AS E_ID, Emp.LoginID, FROM EmployeeDemo AS Emp LEFT JOIN EmployeeDemo AS Mgr ON Emp.ManagerID = Mgr.EmployeeID ORDER BY MgrID, E_ID;
[em]When i execute the above code i get the following error message:[/em]
[strong]Msg 156, Level 15, State 1, Line 4 Incorrect syntax near the keyword 'FROM'. [/strong]
[strong]Any idea's what the problem might be?[/strong]
Software/Hardware used: SQL Server 2008 R2, Windows XP
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!