Antwort: Re: Subtracting fields in the Where Clause

Hi,

you should consider defining a db view returning the computed value
to_days(s.end_of_subscription_date) - to_days(SYSDATE()) as
expiration_days.

You could then simplify your query to look like this:

SELECT user_id
FROM details d, view_subscribers v
WHERE v.app_id = d.app_id
AND v.expiration_days = d.end_warning

which is easy to transform to torque queries.

Hope this helps
Arne


**********************************************************************
http://www.pta.de
Mit 1051 Erfahrungsberichten aus 35 Jahren erfolgreicher Projektarbeit!
**********************************************************************