I got it. I followed this format for joins:

FROM table1 join table2

ON table1.primarykey = table2.foreignkey join table3

ON table2.primarykey = table3.foreignkey

Table number 2 in my database is...

I tried the full outer join and it did the same thing. Although, when I commented out the lines below it brought back one more record that had a value...

I tried commenting the lines out and I retreived 4 records. I looked at the table and found that 3 records fall into the time I have specified.

Also, OrderDate is...