in between dates from 2 tables

[himabinduch]

Hi All,

 i have one date filed in Table A and two date files in table B like below

Table A:

ITEM_ID   , Price_date ,Qty

1,12-02-2019,10

2,12-03-2019,20

Table B:

ITEM_ID,Start_date,End-Date,list-NAME

2,14-02-2019,15-02-2019,TEST

2,1-01-2019,7-01-2019,TEST COMPLETED

now i need to pull the Table B data to Table A base on the price date if the price date fall between start date and end date then i need to pull that record example i should display start date of ITEm_ID 2 is 4-02-2019 and 15-02-2019 though they have two start dates and end dates in the second table.

Thanks 

Hima Bindu Ch

[Kushal_Chawda · Accepted solution]

Date in Table 2 for Item id 2 not falling in any of date range in table b.