Question
-
Topic
-
SQL help required.
Lockedcould someone kindly help me out with the following.
The following query works fine however i need to do the same thing only this time using an explicit join.
select Departments.Deptnumber, Departments.name,
sum (quantity)
from SalesOrderItems, Departments
where Departments.Deptnumber = SalesOrderItems.DeptNumber
group by Departments.Deptnumber, Departments.name;I have tried
select Departments.Deptnumber, Departments.name,
sum (quantity)
from Departments INNER JOIN SalesOrderItems
ON Departments.Deptnumber = SalesOrderItems.DeptNumber
order by Departments.Deptnumber, Departments.name;but keep getting the error
ERROR at line 3:
ORA-00933: SQL command not properly endedany help will be apriciated thanks.
All Answers
Viewing 2 reply threads