Hi All!

I used to have a query that was working in a prior version (11.39.13), but now that I have upgraded to the newest version (11.45.13) this same query is not working any more.

The query is the following:

SELECT
  nrm_tim_date AS nrm_tim_date,
  ( (SELECT SUM(nrm_rse_amount_usd * exc.exc_rate)  from sb_glob.exc_exchange exc where exc.exc_currency = 'USD') ) AS net_profit,
SUM(nrm_rse_amount_usd) AS nrm_rse_amount_usd
FROM sb_traf.cubm_202303 AS nrm    
GROUP BY nrm_tim_date 

The error Im having is "SQL Error [42000]: SELECT: subquery uses ungrouped column "nrm.nrm_rse_amount_usd" from outer query"

This exact same query does work on version 11.39.13.

Can someone help me with this?

Thks a lot in advance