i am getting error like"Each GROUP BY expression must contain at least one column that is not an outer reference."

Question

update abb_account_budget_tmp
set budget_amount =(select sum(isnull(budget_amount,0.0))
                     from abb_analysis_dtl dtl(nolock)
                   where dtl.sub_analysis_code=a.sub_analysis_code
                    and  dtl.company_code = @companycode_tmp
                    and  dtl.fb_id=@fb
                   group by a.sub_analysis_code)

when i am executing this query i am getting error

Answer 1

0

The problem is that there is no such table aliased with "a", hence a.sub_analysis_code should not be used in the sub-query. This is where you get the error. If you can sort out what "a" is, this will get you going.

answered Nov 29 '11 at 02:19 AM

Usman Butt
13.8k ● 6 ● 8 ● 14

(comments are locked)

Answer 2

0

Hi,

The alias name "a" is not referring any table, and work with @Usman Butt answer you may solve this issue

answered Nov 29 '11 at 04:15 AM

sathishkumar
234 ● 15 ● 21 ● 26

(comments are locked)

i am getting error like"Each GROUP BY expression must contain at least one column that is not an outer reference."

Follow this question

Related Questions