The answer depends on the version of SQL you’re using. In some cases, the INNER JOIN syntax results in more efficient processing. The LEFT JOIN: Matching records plus orphans from the left So ...

I've been in an argument with one of our devs that took an update statement with an inner join and made it a left join (because ... as per my understanding of SQL joins): ...

FROM Encoder LEFT JOIN Daily ON Encoder.EncoderID = Daily.EncoderID WHERE Daily.tehDate=#(a date variable)# OR Daily.tehDate Is Null<BR><BR>This appeared to work at first, as I can switch through ...