The RELATE keyword

Previous Next

The RELATE keyword is a USoft-specific extension to the SQL language. It is used in SQL statements that query multiple table instances to introduce an optional RELATE clause.

A RELATE clause is a USoft-specific alternative to writing conventional join conditions in the WHERE clause.

collapseRELATE syntax
collapseComparing RELATE and WHERE
collapseRELATE in transitional constraints


You can only use OLD and NEW on ONE table, the transition table.

You cannot use OLD and NEW in the SQL Definer.

The OLD keyword has different behavior to the OLD() function.


See also



Logical Views