First Guide to SQL Anywhere Studio
PART 3. Basic SQL
CHAPTER 13. Joining Tables
This chapter demonstrates joins using the sample database, asademo.db, included with Adaptive Server Anywhere. The sample database consists of nine tables, storing information about a fictional company.
Each box in the diagram represents a table in the database. The names listed in each box are the column names for the table.
Each box contains a list of the columns in that table. The column name appears first. Next, the letters pk identify those columns that are part of the primary key and fk those that are part of a foreign key. The data type of each column appears last.
The arrows represent foreign key relationships between the tables.
These three new terms are defined below.