posted 10 years ago
Back to the basics, This returns every order item sold
for each customer for each order,
I don't want that, I'd like to have only group by
e.LogCode, I understand the repeating groups
are caused by the multiple group columns
Update
I use select distinct this time, However, it still has repeating rows
Do I have to use group by with select distinct, I tried to cancel the group by
in select distinct, but it results in the same resultset