Re: Tricky query

Simple sum of two queries

1) value/1.14 WHERE  vatInclusive  is true
2)value WHERE vatInclusive is false

should give the correct answer.

Rob wrote:

> Hi all
>
> I want to calculate the value of my stock holdings, which is simply
> latest_stock_count.stock_count * products.cost_price.  I have the
> following query which does this
>
> SELECT p.barcode, (l.stock_count  * p.cost_price) AS value
> FROM latest_stock_count AS l NATURAL JOIN products AS p
> WHERE l.barcode = p.barcode;
>
> The problem is that I always want the cost_price excluding sales tax
> (known as VAT - which is 14%).  So if vatInclusive is true, what I
> actually want is cost_price/1.14, not cost_price.
>
> --
> Rob
>