Thanks Arne. Due to other conditions in the application I will have to loop over the results, but I will use this View technique elsewhere. I appreciate your help.
BR Ruy --- [EMAIL PROTECTED] wrote: > > 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! > ********************************************************************** > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > ===== ------------------------------- I used to be an atheist, until I realized I was God. __________________________________ Do you Yahoo!? Meet the all-new My Yahoo! - Try it today! http://my.yahoo.com --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
