Re: [GENERAL] Duplicate counting

2005-01-20 Thread Aaron Bingham
Jiří Němec wrote: Hello all, I wrote a function which counts price of product from retail price and discount. It works. But I need to count price with tax of same product. The best way is to use counted price and add only a tax. I would like to do by this way: SELECT count_price(retail, discount) A

[GENERAL] Duplicate counting

2005-01-20 Thread Jiří Němec
Hello all, I wrote a function which counts price of product from retail price and discount. It works. But I need to count price with tax of same product. The best way is to use counted price and add only a tax. I would like to do by this way: SELECT count_price(retail, discount) AS price, count_p