hello all,

when i run the following query

Select MAX(BRANCH.NAME) BRNAME,
MAX(CUSTOMER.CUSTNAME) CUSTNAME,
MAX(Extn.Item_ID)
from CUSTOMER,BRANCH,Order
(Select OrdItm_A.Item_ID,
from OrdItm OrdItm_A
where
OrdItm_A.OrdID=Order.OrdID
) Extn
Where
extn.OrdID=Order.OrdID
Group by Branch.Branch_ID
/

It shows the following error though
i have put all the fields in MAX condition

Select MAX(BRANCH.NAME) BRNAME,
*
ERROR at line 1:
ORA-00979: not a GROUP BY expression


Thanx.