Right information, Wrong result

[marra1]

I have a query that is giving me some trouble.

SELECT lender.name, rate.rate, special.special,
IF (
95.00 <= equity.lowLTV, equity.equity, 0.00
) AS equ,
IF (
28000 <=luxury.threshold, luxury.luxury, 0.00) AS lux, (
rate.rate - (special.special + equity + luxury)
) AS net,

tier.maxLTV
FROM lender, rate, term, tier, year, special, equity, luxury
WHERE rate.lenderID = lender.lenderID AND rate.termID = term.termID AND rate.yearID = year.yearID AND lender.specialID = special.specialID AND rate.tierID = tier.tierID AND tier.equityID = equity.equityID AND tier.luxuryID = luxury.luxuryID AND term.minTerm <=66 AND term.maxTerm >=66 AND tier.minScore <=705 AND tier.maxScore >=705 AND year.minYear <=2002 AND year.maxYear >=2002
LIMIT 0 , 30

name rate special equ lux net maxLTV

Bank1 5.39 0.30 0.00 0.25 4.44 125.00
Bank2 5.49 0.30 0.00 0.25 4.54 125.00
Bank3 5.35 0.00 0.00 0.25 4.70 130.00

I am displaying the true or false correctly. but when I use it to calculate my net rate it always displays true. In the above example we have 5.39 -(0.3 + 0.0 + 0.25). It should equal 4.84 not 4.44.

I need your help. I am very new to this. Thanks in advance.

[tomhath]

You display equ and lux, which are calculated in the IF statements.

But then you use equity and luxury in the calculation of net, without the same consideration you used in the IF statements for equ and lux.

[marra1]

Thank You Tomhath!!!

I did not know or understand how to put the conditional in the second part. My script is now working great!!!

Thanks again.