Skip to Content
0
Former Member
Jul 08, 2009 at 07:38 AM

GROUPING IN WEBDYNPRO

30 Views

Dear All,

select * from yts_vw_ts into table itab_ts

where empcode like item_empcode

and deptcode like item_deptcode

and desgcode like item_desgcode

and tsdate >= item_frmdate

and tsdate <= item_todate

GROUP BY TSDATE.

I wrIte this code for grouping.

Its showing this error "The addition "GROUP BY" only make sense with a field list".

Can anybody tell me how to correct this.

Regards,

Arun