budin
Last Activity: Mar 22 '11, 05:54 AM
Joined: Feb 16 '11
Location:
-
SUM + JOIN 2 column
How to set SQL statement to show agent performance and in this case we have 2 agent (id no '1' and '2')
There is 3 sales registered
(1) Fisrt sales by agent no 1 ($2)
(2) Second sales by agent no 1 AND 2 ($3)
(3) Third sales by agent no 2 ($50)
How to display performence every agent base on total sale each agent and sort them base on their personal sales. The result should be like this...
No activity results to display
Leave a comment: