Hi
To me it looks like quantity is being multiplied by the price and then added to
total.
Try something like this
SELECT total,(quantity*price) as QP from sales where total !=QP AND salesid=122
On 2012-12-29, at 7:25 AM, Trimurthy wrote:
> hi,
> i am working with mysql 5.1.36 and i wro
hi,
i am working with mysql 5.1.36 and i wrote the following query.
select total,quantity*price from sales where total != quantity*price and
salesid=122;
OUT PUT:
totalquatity*price
330.46 330.46
here quantity is 15.5 and price is 21.32
both the values and
