Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.1 » UltraLite - Java Programming » UltraLiteJ application development » Code examples


Java SE example: Inner join operations

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 example
  1. Change to the following directory: %SQLANYSAMP12%\UltraLiteJ\J2SE.

  2. Run the CreateDb example:

    rundemo CreateDb
  3. Run the LoadDb example:

    rundemo LoadDb
  4. Run the following command (the command is case sensitive):

    rundemo ReadInnerJoin
 See also