SELECT report.A1 + report.B1 + report.C1 + report.A2 + report.B2 + report.C2 + report.A3 + report.B3 + report.C3 AS 'Total Lives'
FROM `report`
WHERE 'Total Lives' > 0
I know the math is working because i can just run the query and Total Lives is right. If I go 'Total Lives' = 0 it returns all results. I'm not exaclty sure whats going on here. Any ideas?
Last edited by magicrobotmonkey on Fri May 28, 2004 8:05 am, edited 1 time in total.