FROM keyword not found where expected (Oracle) ORA-00923

ora 923ERROR: ORA-00923: FROM keyword not found where expected. How may I fix this. Thanks in Advance! still i got the error. specify the table. Instead of *, use brand.*, PRDUCT.*,ORA-00923: FROM keyword not found where expected Below is the SQL : SELECT A.Agent_key, Sum(Total_Orders) FROM (SELECT A.Agent_key, Sum(Total_Orders)