Joining Tables lets one query combine rows from two tables that share a value. This post uses small Customers and Orders tables to show what INNER, LEFT and FULL OUTER joins return, how many rows each one gives, and how to read the rows that have no match.
SQL – Difference Between INNER JOIN and JOIN
INNER JOIN and JOIN express the same inner join in this T-SQL syntax. I prefer spelling out the join type for readability.
A T-SQL Cheat Sheet for Everyday Work
This T-SQL cheat sheet gathers daily SELECT, JOIN, GROUP BY, window, TRY_CONVERT, and transaction patterns with short examples.
SQL SERVER – Script to Update a Specific Column in Entire Database
A reader added a ModifiedDate column to every table and left it NULL. Here is a script to update a specific column in the entire database at once.
SQL SERVER – DELETE From SELECT Statement – Using JOIN in DELETE Statement – Multiple Tables in DELETE Statement
After my UPDATE from SELECT post, many readers asked about using JOIN in DELETE statement. It is possible, and I show how with multiple tables.
SQL SERVER – UPDATE From SELECT Statement – Using JOIN in UPDATE Statement – Multiple Tables in Update Statement
A developer wrote a cursor because he did not know how to UPDATE from SELECT. I show how to use JOIN and multiple tables in an UPDATE statement.
CROSS APPLY and OUTER APPLY in Everyday Queries
Use CROSS APPLY and OUTER APPLY for per-row functions, reusable expressions, VALUES unpivoting, DMV text, plans, and latest rows.