Join with conditions

[satiyabaazi]

I have a Table A with column H.Date and Table B with columns E.Date and N.Date

Now, I want to see only values in Table A for which H.Date in Table A is between E.Date and N.Date in Table B. I can join Table A and Table B.

I can't seem to get a valid expression to achieve this while inserting a query calculation in the data module. Any help will be highly appreciated!