Posted by Mark on 11/15/07 13:27

Maybe this?

SELECT count(*) FROM tablea A
JOIN tableb B ON ..etc..
WHERE a.string_val = 'test' AND
b.divider > 0 AND
a.number > 0 AND
(a.number / NULLIF(b.divider,0) > 0)

• Next in forum: Re: query performance help needed
• Prev in forum: Division by zero problem
• Thread view: Re: Division by zero problem

[Reply to this message]