Day 5. Joining Tables
In the past several lessons, you might have noticed that the data you have been accessing has been from only one table at a time. You have been looking at order information, but the order is missing things such as the customer name and product number. The strength of a relational database is to be able to access more than one table at a time. Relational database systems get their name from the relationships that are defined between tables. Because most real data is spread out across several tables, you will see how to join tables together.
Table joins are the topic of the day. Understanding joins is central to your understanding of T-SQL, so today's lesson is as important a topic as you can find in this book. The discussions ...
Get Sams Teach Yourself Transact-SQL in 21 Days, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
