>Am I doing something out of the ordinary here? I thought this was a pretty basic query.
>
No you didn't. But both tables are not related, that way SQL Server must compare each record from Table1 with all records in Table2.
BTW with LEFT JOIN you will get as many records as there are matching date intervals in Table2. Can you post some example data and desired result from it?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.