Author Topic: Join with conditions  (Read 756 times)

Offline satiyabaazi

  • Full Member
  • ***
  • Join Date: Sep 2016
  • Posts: 9
  • Forum Citizenship: +0/-0
Join with conditions
« on: 03 Jan 2017 01:55:15 pm »
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!