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