Skip to Content
0
Former Member
Oct 23, 2012 at 07:17 AM

find number of rows without looping and with single select statement.

22 Views

hi gurus,

Need help to find the no of rows in single select statement.
How can i modify the below sql to get count of rows of every field1 in table2?

select table1~field1
table1~field2
from table1
inner join table2
on table1~field1 = table2~field2
into corresponding fields of table alv_table
where....
group by table1~field1 table1~field2.