mysql - 数据库 SQL 查询问题错误 #1066

Question

查询问题:

SELECT B.branchNo, B.city, S.staffNo, fName, lName, propertyNo
FROM Branch B, Staff S, PropertyForRent P
WHERE B.branchNo = S.branchNo AND S.staffNo = P.staffNo
ORDER BY B.branchNo, S.staffNo, propertyNo ;

错误#1066 - 不唯一的表/别名:“B”

我使用了与此类似的查询，它们有效，但这个却不起作用。

我也尝试过:

SELECT B.branchNo, B.city, S.staffNo, S.fName, S.lName, S.propertyNo
FROM Branch B, Staff S, PropertyForRent P
WHERE B.branchNo = S.branchNo AND S.staffNo = P.staffNo
ORDER BY B.branchNo, S.staffNo, propertyNo ;

感谢所有帮助:)

Answer 1

显然它应该有效，或者也许我错过了一些东西，但很奇怪。试试这个:

SELECT B.branchNo, B.city, S.staffNo, fName, lName, propertyNo
FROM Branch B 
JOIN Staff S 
ON B.branchNo = S.branchNo 
JOIN PropertyForRent P
ON S.staffNo = P.staffNo
ORDER BY B.branchNo, S.staffNo, propertyNo