I have about 35 fields in a concatenated table (bills and positions). Does it make sense to add a group by statement if I don't need all of the single positions per bill (only the sum(amount) ? Or is there a better way to get handle this? I'm thinking about this because of a performance issue, processing is quite slow. Thanks for your ideas.
Every position has severals positionnumbers with different articles. Group by doesn't make sense as long as the articles and pos_numbers are in there.
If I use sum (Pos.Amount) and group by %Pos_id, %Pos_number, %Pos_Article.... the result will be (almost) the same as without group by. I think I'll have to kick out the position numbers and articles? Am I right?