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

Lesson 10. Filtering and Displaying Data > Looking Up Foreign Table Data with S...

Looking Up Foreign Table Data with SQL

This page is coming together, but you still haven't resolved the issue of the World Region being displayed as a number, rather than as the name of a continent. In this task, you will solve this problem with some fancy SQL.

Let's revisit the problem, before attempting to solve it. Relationships are the cornerstone of most modern database management systems, such as Microsoft Access. They enable people to organize their data in the most efficient format possible, by eliminating redundancy and simplifying data maintenance. Again, the way they work is that database developers put the unique key from a given table into another table as a foreign key. By doing so, developers can use a query to assemble all information from both tables, correlated to any given record. In tbl_country, there is a field for region, and its value is the unique key taken from tbl_region's unique regionID field.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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