mysql - 错误代码 1241

Question

我不明白我的代码有什么问题以及为什么这个错误不断弹出

CREATE VIEW LocUserComp AS
SELECT concat(location.Loc_Address, location.Loc_City, 
       location.Loc_State) AS Customer_Address, 
      (users.User_FName, users.User_LName) AS Customer_Name
FROM location
JOIN users
ON location.Loc_ID=Users.Loc_ID

Answer 1

在两列两边加上括号。我认为您打算再进行一次 concat():

CREATE VIEW LocUserComp AS
    SELECT concat(l.Loc_Address, l.Loc_City, l.Loc_State) AS Customer_Address, 
           concat(u.User_FName, u.User_LName) AS Customer_Name
    FROM location l JOIN
         users u
         ON l.Loc_ID = u.Loc_ID;