-
not a GROUP BY expression
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|