I am developing a select to introduce me to the notes products from a particular load order. Until then all right, my difficulty is in need of grouping the products of these notes grouped from 3 in 3 notes, that is:
Order of charge 3
NF 1
NF 2
NF 3
.
.
.
NF N
3 X BOLACHA ISABELA
2 X LEITE CONDENÇADO
5 X PIPOCA YOKI
1 X BOLACHA ISABELA
3 X BOLACHA ISABELA
5 X PIPOCA YOKI
2 X BOLACHA RECHEADA TORTINHAS
1 X BOLACHA ISABELA
1 X PIPOCA YOKI
1 X BOLACHA RECHEADA TORTINHAS
The desired result in my SELECT would be this:
separation of the load order 3
7 X BOLACHA ISABELA
2 X LEITE CONDENÇADO
10 X PIPOCA YOKI
----------------------------------------------------------------------------
1 X BOLACHA ISABELA
1 X PIPOCA YOKI
1 X BOLACHA RECHEADA TORTINHAS
in the first block of products presented would be grouped the products from Notes 1, 2 and 3. in the second block the notes 4, 5 and 6 and so on.
Does anyone know any role where I could do this grouping?
Thanks for the attention.