Lesson 8. Building SQL Statements Based on Multiple Tables
Now that you’ve learned the basics of the T-SQL language, you’re ready to move on to more advanced techniques. To really take advantage of what T-SQL has to offer, you must know how to return recordsets that contain data based on multiple tables. In this lesson, you learn:
What inner joins are and how to implement them
What outer joins are and how they differ from inner joins
How to output ...