First Guide to SQL Anywhere Studio
PART 3. Basic SQL
This chapter describes database queries that look at information in more than one table. To do this, SQL provides the JOIN operator. There are several different ways to join tables together in queries, and this chapter describes some of the more important ones.
The sample database
Displaying a list of tables
Joining tables with the cross product
Restricting a join
Self joins
How tables are related
Join operators