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.