scarydba.com
Database Fundamentals #19: JOINS - Grant Fritchey
The last Database Fundamentals post introduced the SELECT and FROM commands. We’re going to start using JOIN operations shortly, but first, let’s explore the idea behind joins. The very concept of relational storage that is the foundation of SQL Server requires you to related one table to another. You do this through a operation called …