I'd like to write a criteria that subtracts two columns and then checks to see if the result is greater than zero. The SQL would look something like this
select * from supplier where (assignmentCapacity - actualAssignments) > 0 Has anyone done something similar to this? Any ideas? Thanks! -Mike -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
