Contents Index Joins: Retrieving Data from Several Tables How joins work

ASA SQL User's Guide
  Joins: Retrieving Data from Several Tables

Sample database schema


This chapter makes frequent reference to the sample database. In the following diagram, the sample database is shown with the names of the foreign keys that relate the tables. The sample database is held in a file called asademo.db, and is located in your installation directory.

The Adaptive Server Anywhere sample database, including tables, column names, primary keys, and foreign key relationships.

Contents Index Joins: Retrieving Data from Several Tables How joins work