oracle 9i, sql

[cesarnz]

hi all,
i have an sql statement where i gather all the employees who have sold a product given a certain time period. I can get the data without much problem but the results look like they could be better "grouped". I get this at the moment :


employeename, productID, productType, date, soldAmount

tom 100 1 12/08/2009 1
tom 100 1 12/08/2009 1
tom 100 1 12/08/2009 1
tom 100 1 12/08/2009 1
tom 102 4 12/08/2009 1
tom 102 4 12/08/2009 1



Looking at the results i can see tom sold 4 products (id=100) so i wanted to display something like :



employeename, productID, productType, date, soldAmount

tom 100 1 12/08/2009 4
tom 102 4 12/08/2009 2


any suggestions on how to do this ?? sql so far is :

select employee.name, product.productID, product.productType, sales.date, count(product.productType) "soldAmount"
FROM employee, product, sales WHERE ....
GROUP BY employee.name, product.productID, product.productType, sales.date
ORDER BY count(product.productType)

 

[Turkbear]

Hi,
Why are you having the Sql query ( I assume a command) do all the work instead of having Crystal handle the count, group and order?
How many rows of data are you expecting?





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[cesarnz]

hi,
i dont have access to any reporting tools like crystal so need to format everything in sql command line.

 

[Turkbear]

Hi,
Then this should be posted to the

Oracle: Oracle Release - 9i forum

http://www.tek-tips.com/threadminder.cfm?pid=186cle:

To Paraphrase:"The Help you get is proportional to the Help you give.."