>>>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.
>>>
>>I understand, but still may you try two inner joins (one with table1 to table2) and another with (table2 to table1) and see, if there is any difference? Perhaps there would not be one.
>
>You have me thoroughly confused... :-)

I'm just curious to see the results, I guess, there would not be any difference, but I don't know till you try. Just try two simple queries in QA with your tables.