UNRELATED

In a set specification, selects non-matching members of an EntitySet, a relationship with fields, an application document, or a result set.

Syntax

object (UNRELATED)

Parameters

Comments

In a set specification, UNRELATED selects all records in object that do not satisfy the relationship condition expressed in the set specification.

UNRELATED can be used only once in a set specification.

This function is related to the theoretical partial outer join operation.

Example

> find all Employees (unrelated) WorkIn Departments

> list all
LastName  FirstName  DeptNum  DeptName DeptNum
Johnston  Leslie   D07
Nelson    John
Kelly    Pat

The preceding command finds all employee records that contain no DeptNum, or contain a DeptNum for which there is no corresponding department record. Missing values are undefined ($Null).

find all Employees WorkIn Departments (unrelated) keep Departments

The preceding command creates a list of all departments that have no employee records associated with them.

find all Managers (unrelated) Manage Employees

Finds all employees that do not manage anyone. (For a contrasting example, see COMPLETE.)

See Also

– (Dynamic Rename)

COMPLETE

USING

INTERSECT

Isolates the common members of two or more result sets.

Syntax

set1 INTERSECT set2

Parameters

Comments

When used within a FIND command, the result set contains the members that are common to each of the specified result sets, with duplicates eliminated.

See Also

FIND

MINUS

UNION

MINUS

Removes the members of one or more result sets from a another result set.

Syntax

set1 MINUS set2

Parameters

Comments

When used within a FIND command, the result set contains all members of set1 that are not also in set2, and so on.

See Also

INTERSECT

Set Specification

UNION