You're doing a left join on the Encoder Table, which means give me ALL the results from that table, and then give me any matching results from Daily.<BR><BR>If the only instance of EncoderID #1 in ...