This example demonstrates how to perform an inner join operation. In this scenario, every employee has corresponding department information. The join operation associates data from the employee table with corresponding data from the department table. The association is made with the department number in the employee table to locate the related information in the department table.
Run the ReadInnerJoin.java exampleChange to the following directory: %SQLANYSAMP12%\UltraLiteJ\J2SE.
Run the CreateDb example:
rundemo CreateDb |
Run the LoadDb example:
rundemo LoadDb |
Run the following command (the command is case sensitive):
rundemo ReadInnerJoin |
See also |
Discuss this page in DocCommentXchange.
|
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1 |