4.6 Join Query

The following query joins a base class table with an auxiliary class table. It reads the O column which is part of the Organization table and the Synchronized Up To_Time column which is part of the Partition table.

SQL Statement

 SELECT O, "Synchroinzed Up To_Time"
 
 FROM Organization, Partition
 
 WHERE Organization.NDS_FullName=Partition.NDS_FullName

Result Table

Table 4-4 Join Query Result Report

O

Synchronized Up To_Time

Operations

2000-02-18 13:06:41.000

Enginerring

2000-02-19 09:03:23.000