You can specify the right-to-left and left-to-right cardinality of a join. Table 7-10 lists the cardinality types and a description of each type.
Table 7-10 One record in the first table matches one record in the second table. One record in the first table matches zero or one record in the second table. One record in the first table matches zero or more records in the second table. One record in the first table matches one or more records in the second table.The right-to-left cardinality type is followed by a hyphen (-), and then by the left-to-right cardinality type. The cardinality type depends on the join column.Customers JOIN Orders ON (Customers.custid = Orders.custid) {CARDINALITY ('1-+')}Customers JOIN Orders ON (Customers.custid = Orders.custid) {CARDINALITY ('1-*')}Customers JOIN Orders ON (Customers.custid = Orders.custid) {CARDINALITY ('*-?')}
|
|
Copyright Actuate Corporation 2012 |