topic Select query where codn in Application Development and Automation Discussions

Select query where codn

Former Member — Thu, 04 Sep 2008 06:15:56 GMT

Hi in my requirement in a select query i have to place a where codn using asset value date.Actually the asset value date has from date and end date.The from date is present in a table and end date is present in another table so now how to put the where codn.Please give some suggestions.

Re: Select query where codn

Former Member — Thu, 04 Sep 2008 06:25:48 GMT

Hi hema,

Use subquery as follows;

Select.....
.....Where asset_date BETWEEN (Select single asset_fromdate from fromdate_table where key_field = value) AND (Select single asset_todate from todate_table where key_field = value)

Hope this helps you...

Regards

Karthik D