我正在嘗試學習 JOINS，但我無法讓這個作業。嘗試將第二個表連接到第一個表以獲取磁區的名稱，即 dname 變數。
select e.COUNT(empID), e.SUM(salary), e.DID, d.dname
from employee e
right join division on e.DID=d.DID
group by DID
uj5u.com熱心網友回復：
select COUNT(e.empID), SUM(e.salary), e.DID, d.dname
from employee e
right join division d on e.DID=d.DID
group by e.DID, d.dname
uj5u.com熱心網友回復：
您錯過了Groupd上division和 Group 上的別名，并且別名進入了 select 行上的函式呼叫
select COUNT(e.empID), SUM(e.salary), e.DID, d.dname
from employee e
right join division d on e.DID=d.DID
group by e.DID
轉載請註明出處，本文鏈接：https://www.uj5u.com/qiye/346755.html