I want my results to have a record for every day, which is why I put Table1 first. Plus I don't want to do an inner join because there are plenty of records in Table1 that won't have a corresponding value in Table2, and I still want to show them.
>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.
>>