Ars Technica

SQL: Union Join or Full Outer Join in Oracle 8i

I need to form the equivalent of a Union Join in Oracle 8i, even though a Union Join doesn't appear to be supported in 8i. I might be able to manipulate a Full Outer Join to get the results I need, ...
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 ...
TechRepublic

Understand the effects of NULLs on inner and outer JOINs

Understand the effects of NULLs on inner and outer JOINs Your email has been sent SQL Server developers must understand two things: the difference between inner and outer JOINs and the effect of NULLs ...
InfoWorld

SQL lessons for NoSQL developers

Because no software developer is complete without at least a passing knowledge of the world’s most popular query language If yo were raised on MongoDB or learned full stack development in a coding ...