Did you try (just in case) to switch tables around, e.g.
select * from Table2 ;
inner join table1 ;
on table2.StartDate <= table1.RecordDate and table2.EndDate >= table1.RecordDate
>Table1 contains a record for each day that contains certain interest rates.
>Table2 contains a record for a range of days (specified by StartDate and EndDate - no overlap) that contains other interest rates.
>
>I want to link the tables, and view the corresponding Table2 record with each Table1 record. The tables are unrelated otherwise.
>
If it's not broken, fix it until it is.
My Blog