• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part I: Creating Powerful Queries > Working with Multiple-Table Queries

Chapter 3. Working with Multiple-Table Queries

IN THIS CHAPTER

Relational Database Fundamentals

Types of Relational Models

Enforcing Referential Integrity

Establishing Table Relationships

Working with Multiple Tables in a Query

Creating Other Types of Joins

Creating a Unique Values Query

Case Study

Most database applications (and all well-designed database applications) store their information in multiple tables. Although most of these tables have nothing to do with each other (for example, tables of customer information and employee payroll data), it's likely that at least some of the tables do contain related information (such as tables of customer information and customer orders).


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint