Sum the total Defects

[intscript]

Hello Everybody,

How can I combine then compute the sum of totalDefects of this 2 Select statement in one Select Statement

Select sum(nDefects) Defects
from tbl_ProcessDefects
where vcLotNo ='11' and iDefectId = '0'
Defects = 5


Select sum(nDefects) Defects
from tbl_ProcessDefects
where vcLotNo ='3' and iDefectId = '0'
Defects = NUll meaning 0

When I get the total, should be 5..i also tried this

Select sum(nDefects) Defects
from tbl_ProcessDefects
where vcLotNo ='11' and and vcLotNo = '0'i DefectId = '0'

The Out is now Null instead of 5.

Thanks

[ronverdonk]

Select sum(nDefects) Defects
from tbl_ProcessDefects
where vcLotNo ='11' and and vcLotNo = '0'i DefectId = '0'

That is an impossible clause. You cannot have a field having a value '11' and '0' at the same time!! So probably your statement should be

SELECT SUM(nDefects) as Defects
    FROM tbl_ProcessDefects 
    WHERE (vcLotNo ='11' OR vcLotNo = '0') AND iDefectId = '0' 

Next time put your code statements within code tags, so it is better readable!

Ronald :cool: