我得到错误ERROR 1066 (42000): Not unique table/alias:
我不知道它有什么问题。
SELECT Project_Assigned.ProjectID, Project_Title, Account.Account_ID, Username, Access_Type
FROM Project_Assigned
JOIN Account
ON Project_Assigned.AccountID = Account.Account_ID
JOIN Project
ON Project_Assigned.ProjectID = Project.Project_ID
where Access_Type = 'Client';
发布于 2011-11-11 03:17:23
您的查询包含的列可能在您引用的多个表中具有相同的名称,因此出现not unique错误。最好是显式引用和/或在连接时使用表别名。
试一试
SELECT pa.ProjectID, p.Project_Title, a.Account_ID, a.Username, a.Access_Type, c.First_Name, c.Last_Name
FROM Project_Assigned pa
INNER JOIN Account a
ON pa.AccountID = a.Account_ID
INNER JOIN Project p
ON pa.ProjectID = p.Project_ID
INNER JOIN Clients c
ON a.Account_ID = c.Account_ID
WHERE a.Access_Type = 'Client';
发布于 2017-07-18 04:37:37
select persons.personsid,name,info.id,address
-> from persons
-> inner join persons on info.infoid = info.info.id;
https://stackoverflow.com/questions/8084571
复制相似问题