I have the follow query



Select

Customer.name customer_name,

(select sum(rest) from movements where movements.customer=customer.code)
entity_rest

Where

Customer.deleted=0



I want to add at where statement the follow comparison

And entity_rest <>0



But the column is "unknown" (ok, it is really unknown).



Except to work with outer joins, how may I express this comparison?



Dennis





[Non-text portions of this message have been removed]