next up previous contents index
Next: Table and Column References Up: PostgreSQL: Introduction and Concepts Previous: Summary

  
Joining Tables

 This chapter discusses how to store data using multiple tables. Both multitable storage and multitable queries are fundamental to relational databases .

We start this chapter by examining table and column references, which are important in multitable queries. Then, we cover the advantages of splitting data into multiple tables. Next, we introduce an example based on a mail-order company, showing table creation, insertion, and queries using joins. Finally, we explore a variety of join types.


 


Bruce Momjian
2001-05-09