These WHERE clauses
enable you to define links between any two tables using free definition
table fields. Compared table fields can either be part of the same or of
different tables.
However, table types must be identical. |
|||||||||||||||||||
Syntax: |
|||||||||||||||||||
{STR_EXPR}{WHR_CMP}:{STR_EXPR} | |||||||||||||||||||
|
|||||||||||||||||||
Example: |
|||||||||||||||||||
Definition of a selection condition as argument of a 'where' command (part of the combined select instruction):
where("MAT.MAX_WIDTH" = :"MAT.ISO") |
|||||||||||||||||||
Result: | |||||||||||||||||||
Records of the "MAT" table are selected whose "MAX_WIDTH" and "ISO" fields have the same contents. |
|||||||||||||||||||
![]() |
'Select' command, integer function 'exec_select', keywords: 'art_agg', 'art_ref', 'art_typ'. |