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 ...

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 ...

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): ...