Joins

  • Alex Reprintsev
Chapter

Abstract

Most real-life queries combine data from multiple tables instead of querying a single table. Logic may be encapsulated in a view to hide complexity from the end user, but the database accesses multiple tables anyway to get the result set. It’s not necessary that data from all tables in a query appear in the result; some tables may be used to filter out data from other tables, for example.

Copyright information

© Alex Reprintsev 2018

Authors and Affiliations

  • Alex Reprintsev
    • 1
  1. 1.LondonUK

Personalised recommendations