ORA-00918:当我尝试更改Select语句中的列名时，列定义不明确.Oracle

Question

当我使用它时，我会得到非常好的表：

Select B.bid, B.title, B.sellingprice, A.authid, A.sname, A.fname, AL.payrate  
From Book B
Inner Join Allocation AL
ON B.bid = AL.bid
Inner Join Author A
ON AL.authid = A.authid
Order by bid, authid;

但当我尝试这样更改列时，会出现错误：

Select B.bid as "Book ID", B.title as "Title", B.sellingprice as "Selling Price", A.authid as "Author ID", A.sname as "Surname", A.fname as "First Name", AL.payrate as "Payrate"  
From Book B
Inner Join Allocation AL
ON B.bid = AL.bid
Inner Join Author A
ON AL.authid = A.authid
Order by bid, authid; 

ORA-00918：列定义不明确的

Answer 1

用适当的表名限定order by子句中的列名：

Select B.bid as "Book ID", 
B.title as "Title", 
B.sellingprice as "Selling Price", 
A.authid as "Author ID", 
A.sname as "Surname", 
A.fname as "First Name", 
AL.payrate as "Payrate"  
From Book B
Inner Join Allocation AL
ON B.bid = AL.bid
Inner Join Author A
ON AL.authid = A.authid
Order by B.bid, A.authid;