sql - SQL逗号错误

Question

我正在为学校分配SQL作业，这是我正在查询的内容。

SELECT 
    Regions.RegionName, Countries.CountryName, 
    (Employees.LastName + ', ' + Employees.FirstName) AS EmployeeName, 
    (EmployeeTitles.Title + ' ' + CAST (Employees.Level AS VARCHAR), 
    Employees.Salary
FROM 
    Regions, 
    Countries, 
    Employees, 
    EmployeeTitles
WHERE 
    Regions.RegionID = Countries.RegionID AND
    Countries.CountryID = Employees.CountryID AND
    Employees.TitleID = EMployeeTitles.TitleID
ORDER BY 
    RegionName, 
    CountryName, 
    LastName, 
    Title, 
    Salary;

给我错误的逗号在“Cast(Employee.Level AS VARCHAR)”之后，并给我一个错误，说“'，'附近的语法不正确-”

谢谢。

Answer 1

在逗号之前，您已经错过了右括号。

(EmployeeTitles.Title + ' ' + CAST (Employees.Level AS VARCHAR), 

应该成为

(EmployeeTitles.Title + ' ' + CAST (Employees.Level AS VARCHAR)),