Advertisement

Chapter 4: Querying from Multiple Tables

by Jonathan Gennick
  • Jason Brimhall
  • Jonathan Gennick
  • Wayne Sheffield

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

Phone Number Parent Query Exist Predicate Union Query Sales Quota 
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.

Copyright information

© Jason Brimhall, Jonathan Gennick, and Wayne Sheffield 2015

Authors and Affiliations

  • Jason Brimhall
    • 1
  • Jonathan Gennick
    • 1
  • Wayne Sheffield
    • 1
  1. 1.UTUS

Personalised recommendations