Dear All,
outer select not working (ORA-00979 : not a group by expression)
When executing without an outer select it is working fine. Also without the db link in source schema it is working fine. But we need to connect to the source through dblink for certain reporting requirements. Is there any work around or solution to resolve this error? any help will be highly appreciated.
select customer,customer_mobile,account_Number,outstanding_amount
from
(
select customer,customer_mobile,sales.get_Account_number@dblink(s.customer) account_Number,sum(outstanding_amount)outstanding_Amount from sales.sales_Detail@dblink s where
customer='abc'
group by customer,customer_mobile,sales.get_Account_number@dblink(s.customer)
)