SUM A COLUM GROUPED BY ANOTHER [message #692] |
Wed, 27 February 2002 01:51 |
Antoni
Messages: 8 Registered: February 2002
|
Junior Member |
|
|
HI
I HAVE A TABLE LIKE THIS ONE:
TABLE PURCHASING
COLUMN 1 CLIENT CODE PK
COLUMN 2 PRODUCT CODE PK
COLUMN 3 PURCHASE PK
SO THAT I CAN HAVE A CLIENT THAT HAS BOUGHT THE SAME PRODUCT SEVERAL TIMES. I WANT TO KNOW THE TOTAL PURCHASE FOR EACH PRODUCT, GROUPED BY CLIENT AND PRODUCT
I AM DOING THIS, BUT IT IS NOT WORKING
SELECT DISTINCT CLIENT CODE, PRODUCT CODE, PURCHASE FROM TABLE PURCHASING GROUP BY CLIENT CODE, PRODUCT CODE, PURCHASE CODE;
THANK YOU
|
|
|
|
|