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

SAP Sybase SQL Anywhere 16.0 » UltraLite - Java Programming » UltraLiteJ application development » Code examples


Java SE example: Inner join operations

Run the Java SE sample to understand how to perform an inner join operation.


There are no prerequisites for this task.

Context and remarks

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.

  1. Change to the following directory: %SQLANYSAMP16%\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


The applications run successfully. The Employee table is read and each row is joined to the corresponding row in the Department table.

 See also