Tables can be related by matching a specified link value in one table with values in a specified key or column in another table. When the link is a column or key, a relationship forms when CA Dataquery finds a row in table2 containing the same value in the named key or column. CA Dataquery relates the row found in table1 to the row in table2 to create a composite row in the active found set. It is possible to retrieve rows whose values do not match by using an outer join keyword rather than RELATE. See Outer Joins.
Sample Query
The following sample RELATED BY clause has a key as a link.
FIND ALL TABLE1 ROWS
WITH STATE = 'NY'
RELATED BY KEY1 VIA KEY2 TO TABLE2
Key or Column Link Example
Additional Information
You can use the outer join keywords to retrieve the remaining rows. See Outer Joins for details.
|
Copyright © 2014 CA.
All rights reserved.
|
|