Evening Gurus,
I have a small problem that I've beaten to death the past 2 days. I am
trying to get the value of a row, and update another table accordingly.
The data within the row is either a 1 or 0. My issue is in trying to
increment a count for both 1's and 0's.
In other words, I want
Thankyou kindly Bill. Just to verify, SUM adds up values. My data
is only 1 or 0. I used SUM as an example, the below query you recommend
will count all 'rows' which are 0, thus returning a number which
represents how many 0's were found?
Thankyou for the fast reply,
Calvin
On Thu, 30 Aug 2001,
Evening Jay,
I'm still abit new to MySQL. Spending the last 6 months I have worked
with it more on my CGI development, than good SQL query practicing. My
technical jargon is lacking. In laymens terms ( I know no other at this
point in time ) I have a row that has '1' or '0' in it. I'm trying to