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.

Former Member
Former Member replied

Hi hema,

Use subquery as follows;

.....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...


Karthik D

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