Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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.

Tags:
Former Member
Former Member replied

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

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question