Skip to Content
avatar image
Former Member

Select query where codn

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.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Sep 04, 2008 at 06:25 AM

    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

    Add comment
    10|10000 characters needed characters exceeded