Sum columns

[blackbox]

Hi all,

I have a query that should sum the content of each column and display the results but I am getting an odd result;

I know that record 1 field 'SeqID0101' has a value of 1 but the query brings back 4, the other fields may or may not contain a value.

There is another record 'record 2' where the field 'SeqID0102' contains '3' which is where the end result is coming from 1+3 = 4

SeqID0101 contain 1
SeqID0102 contains 3

SELECT 
SUM(SeqID0101) ,
SUM(SeqID0102) 
FROM
LONRU_Audit
WHERE SeqID0101 = 1 OR SeqID0102 = 1

The query is wrong that for sure but how should the query be. Can anyone see why the field 'SEQ0102' is SUMMING where the content is '3'.

Many thanks in advance

[NogDog]

I suspect the issue is that you will sum each column in each and every row where either the first or second field has a value of 1, so in this sample data set...

SeqID0101  SeqID0102
     1         3       (counted, first is 1)
     3         4       (NOT counted, neither is 1)
     2         1       (counted, 2nd is 1)
     1         1       (counted, both are 1)
=========  ==========
     4         5

[NogDog]

You might be able to do something ugly like

SELECT
  SUM(IF(SeqID0101 = 1, 1, 0)),
  SUM(IF(SeqID0102 = 1, 1, 0))
FROM . . .