Skip to Content
0
Former Member
Feb 17, 2012 at 11:14 AM

problem with for all entries in select querry

2033 Views

hi,

Hi,

I am using select queery like this

SELECT  version  COUNT( * )  
from ztbi_default_va4 
INTO  CORRESPONDING FIELDS OF TABLE   lit_new  
FOR ALL ENTRIES IN lit_new1 
WHERE network = lit_new1-network GROUP BY version.

this is not working showing error as:

The addition "FOR ALL ENTRIES" excludes all aggregate functions with

the exception of "COUNT( * )" as the single element of the SELECT clause.

I am using only count(*) ,not using othes like max,min etc,,,,,,,,,

please suggest any missing in syntax,,,,attach relavant code using count(*) with for all entreis

any help appriciated,,,,,

Thanks in advance,,,,