JOIN Types

Left Outer Join (Left Join)

by SteveStedman
January 16, 2023December 27, 2022
JOIN Types

In SQL, a LEFT OUTER JOIN is a type of JOIN operation that combines data from two tables, based on a JOIN condition. This type… Read More »Left Outer Join (Left Join)

Left Outer JOIN with Exclusion

by SteveStedman
January 13, 2023December 6, 2024
JOIN Types

A left outer join with exclusion is a variation of the standard left outer join used to find rows from the left table that do… Read More »Left Outer JOIN with Exclusion

Inner Join versus Outer Join

by SteveStedman
January 11, 2023November 25, 2024
JOIN Types

Inner Join versus Outer Join, A SQL Server inner join is a type of join that combines records from two or more tables in a… Read More »Inner Join versus Outer Join

November is SQL class discount month

by SteveStedman
November 1, 2022October 15, 2022
Classes, JOIN Types

It is that time of the year again, November, the month where we have the lowest prices on our SQL Server courses, and where we… Read More »November is SQL class discount month

Stedman Solutions Coupons and Deals

by SteveStedman
July 14, 2022June 13, 2022
Classes, CTE Book, Database Health, JOIN Types, Ransomware, SchemaDrift

Current SQL Server course coupon codes and on going deals you can only get from Stedman Solutions! 25% Off in July! Coupon Code: DATABASEHEALTH Learn… Read More »Stedman Solutions Coupons and Deals

Course Coupons and Stedman Solutions Deals

by SteveStedman
June 9, 2022June 1, 2022
Classes, CTE, CTE Book, JOIN Types, Ransomware

Current Stedman Solutions SQL course coupon codes and on going deals you can only get from Stedman Solutions! 50% Off Our Newest Course! Coupon Code:… Read More »Course Coupons and Stedman Solutions Deals

What is your favorite SQL Server Developer Interview questions?

Over the last 30+ years of working with SQL Server, I have seen a lot of interview questions relating to SQL Server. I have been… Read More »What is your favorite SQL Server Developer Interview questions?

SQL Course Coupon Codes

by SteveStedman
April 22, 2022April 22, 2022
Classes, CTE, CTE Book, JOIN Types, Ransomware, TSQL

Current Stedman Solutions SQL Course Coupon Codes. Save Up to 65% Off our Popular Online SQL Server Courses, a Once a Year Type Savings! 65%… Read More »SQL Course Coupon Codes

JOIN Types Poster Applause

by SteveStedman
April 12, 2022March 24, 2022
Classes, JOIN Types, TSQL

When I first created this JOIN Types poster or cheat sheet back in 2013 I didn’t realize there was such a need for it. I… Read More »JOIN Types Poster Applause

Understanding JOINs Month

by SteveStedman
April 1, 2022April 1, 2022
Classes, JOIN Types, TSQL

Joining tables in SQL Server can be confusing and hinder your performance. I know because I have helped many confused people to understand their JOINs.… Read More »Understanding JOINs Month