09-04-2008 7:15 AM
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.
09-04-2008 7: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
09-04-2008 7: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