Error-Each GROUP BY expression must contain at least one column that

Ramco Ramco

4y1.4k

Error - Each GROUP BY expression must contain at least one column that is not an outer reference.

SELECT
   T1.U_VendCode,T1.U_CabNo,T1.U_VendName as "Vendor Name",Count(*),
   (Select Count(*) from [tbl2] where T1.U_APDE <> 'N'
   group by T1.U_VendCode,T1.U_CabNo,T1.U_VendName,T1.U_Custcode,T1.U_Custname,T1.U_APDE,T1.U_ARDE,T1.U_ItemCode),
   T1.U_CustCode as "Cust Code",T1.U_CustName as "Cust Name",T1.U_ItemCode
   FROM [tbl1] T0
   inner join [tbl2] T1 on T0.Docentry = T1.DocEntry
   where (T1.U_ItemCode is not null) and (T0.U_DATE BETWEEN '2021-03-01' and '2021-03-31' )
   and T1.U_CustCode = 'A01'
   group by T1.U_VendCode,T1.U_CabNo,T1.U_VendName,T1.U_Custcode,T1.U_Custname,T1.U_APDE,T1.U_ARDE,T1.U_ItemCode

Thanks

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Satya Karki4y ago
Hi, check the below link, this may help you.

https://stackoverflow.com/questions/4453517/each-group-by-expression-must-contain-at-least-one-column-that-is-not-an-outer-r

Ramco Ramco4y ago

I tried below but same problem

SELECT  T1.U_VendCode,T1.U_CabNo,T1.U_VendName as "Vendor Name",Count(*), (SELECT Count(*) FROM [@IND_RLS1] WHERE U_APPrsd = 'Y'  group by T1.U_VendCode,T1.U_CabNo,T1.U_VendName,T1.U_Custcode,T1.U_APDE,T1.U_ARDE,T1.U_ItemCode ) as AP  FROM [tbl1] T0						 inner join [tbl2] T1 on T0.Docentry = T1.DocEntry where (T0.U_DATE BETWEEN '2021-03-01' and '2021-03-31' ) and T1.U_CustCode = 'SSC00003' group by T1.U_VendCode,T1.U_CabNo,T1.U_VendName,T1.U_Custcode,T1.U_APDE,T1.U_ARDE,T1.U_ItemCode

Thanks