Abstract
It is the rare database that has all its data in a single table. Data tends to be spread over multiple tables in ways that optimize storage and ensure consistency and integrity. Part of your job when writing a query is to deploy and link together T-SQL operations that can operate across tables in order to generate needed business results.
Keywords
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2015 Jason Brimhall, Jonathan Gennick, and Wayne Sheffield
About this chapter
Cite this chapter
Brimhall, J., Gennick, J., Sheffield, W. (2015). Chapter 4: Querying from Multiple Tables. In: SQL Server T-SQL Recipes. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-0061-2_4
Download citation
DOI: https://doi.org/10.1007/978-1-4842-0061-2_4
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-0062-9
Online ISBN: 978-1-4842-0061-2
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books