The INNER JOIN version of the query This kind of query, in which results contain only records that contain matching values in both tables, is known as an INNER JOIN.

I'm a total SQL n00b, so forming complex SQL statements is kind of new to me. I'll give your query a shot tomorrow and let you know how it goes.<BR><BR>Thanks!

Aside from those restrictions, running the code in compatibility level 140 (the default for SQL Server 2017) will automatically improve use interleaved execution where possible. • Batch-mode execution ...

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 inner was missing some records somehow in the left table - tableB in ...

In this SQL Server tip, Arthur Fuller explains the effects of NULLs, and the different results obtained by inner and outer JOINs.