could 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 ended
any help will be apriciated thanks.
