This chapter shows how to store data using multiple tables. Multi-table storage and multi-table queries are fundamental to relational databases.
We start this chapter with table and column references. These are important in multi-table queries. Then, we cover the advantages of splitting data across multiple tables. Next, we introduce an example based on a mail order company, showing table creation, insertion, and queries using joins. Finally, various join types are explored.