Select b.cfk1, b.cfk2, a.ctype; FROM vcf!many b ; INNER Join vcf!one a ON b.cfk1 = a.cid; WHERE (b.namount1 + b.namount2 <> 0) or ; (b.namount3 <> 0 and a.ctype$"F8" ) ; GROUP By b.cfk1, b.cfk2which should use short circuiting a bit better.
WHERE (b.namount1 + b.namount2 > 0) or ; (b.namount1 + b.namount2 < 0) or ; (b.namount3 <> 0 and a.ctype$"F8" ) ;HTH