Ars Technica

SQL HELP: *= not the same thing as LEFT OUTER JOIN?

</pre><BR><BR><BR>So, if I wanted a report on the total amount a user has spent, I would add the initial and subsequent expenditures and subtract the credits. So, Bob would have a total of $100.00 ...
TechRepublic

Understand the effects of NULLs on inner and outer JOINs

In this SQL Server tip, Arthur Fuller explains the effects of NULLs, and the different results obtained by inner and outer JOINs. SQL Server developers must understand two things: the difference ...
Ars Technica

Settle an argument: SQL update with left join + isnull() vs inner join

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