Join(field)
Joins a table to which the field belongs with the table to which the argument field belongs. Joining tables is performed on value equality between the field and the argument field. The field must belong to the Query::Fields collection and must not be the calculated one. The argument field must belong to the Table::Fields collection and must be indexed if it belongs to a GDB table. The fields must have the same type. The fields of type gdbFieldTypeOLEObject cannot be joined. It is impossible to use this method if the field belongs to an external database query based on an SQL statement SELECT. Not all external databases support using the same table two or more times in joining tables. To determine this, use the ExternalDatabase::CanMultiJoinTable property. For queries based on GDB tables, it is impossible to use a table two or more times in joining. After joining the table, fields of joined table are added to the Query::Fields collection.
 |  |
