Abstract
Now that you know how to write simple queries using one table and how to use functions and expressions in queries, it is time to learn how to write queries involving two or more tables. In a properly designed relational database, a table contains data about one thing or entity. For example, an order-entry application will have a table storing customer information, a table containing data about orders, and a table containing detail information about each item ordered. The order table has a column, called a foreign key, that points to a row in the customer table. The detail table has a foreign key column that points to the order table. By using joins, you can link these tables together so that you can display columns from each table in the same result set.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Rights and permissions
Copyright information
© 2012 David Guerineau
About this chapter
Cite this chapter
Shaw, S., Kellenberger, K. (2012). Querying Multiple Tables. In: Beginning T-SQL 2012. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4302-3705-1_4
Download citation
DOI: https://doi.org/10.1007/978-1-4302-3705-1_4
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4302-3704-4
Online ISBN: 978-1-4302-3705-1
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books