Java SE example: Inner join operations

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

Prerequisites

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.

Task

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

Results

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

Java SE example: Inner join operations

Task

See also