Checking Date Values in Resident Tables on Loading

[#1]

Hi,

I have 2 tables both with date fields. I am trying to create a 3rd table loading Cust Numner from Table1 where Table 2 date is greater than a date in Table 1 and less than another Date in Table 1

e.g.

Table1:

From_date,

To_date,

Cust_no

Table 2:

Check_Date

Table 3

load

Cust_no

resident Table1

where

(Table1) From_date < (Table2)Check_Date < (Table1)To_date

Would anybody have any ideas ??

Thanks