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

Chapter 2. Joins and Cascades > Referential Integrity

Referential Integrity

Notice in Figure 2.13 that the only records that match are 4 through 6. If you hook up the two tables with a left join, then you are going to have three dangling records in table B. If table A is Customers and table B is Orders, you have orders without Customers.

Figure 2.13. This diagram shows that table B has no matching records for records 1 through 3 in table A.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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