Home extract record on basis of date span
Reply: 0

extract record on basis of date span

user596 Published in June 22, 2018, 11:33 am

I have 2 tables MEMBEN and MEMELIG, data is as below.

MEMBEN details:

MEMELIG details:

i want to join two tables in such way that it does not give cartesian product but selective data on basis of datespan of Benefit eff and benefit end date, so consider for above example we take member with id = '1001',

below picture contains all details which i am looking for.

Expected result details

Please help on this i tried using WITH clause but not able to proceed with result.

You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.319711 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO