Affects Version/s: 1.2.0-ALPHA1, 1.2.0-ALPHA2, 1.2.0-ALPHA3, 1.2.0-BETA1, 1.2.0-BETA2, 1.2.0-BETA3, 1.2.0-RC1, 1.2.0, 1.2.1, 1.2.2, 1.2.3
Fix Version/s: None
Environment:Windows Server 2003 SP2
I have 2 tables.
id [Primary Key]
t2_id [related to t2.id]
primary key: id
id [related to t1.t2_id]
fixed_set [predefined set of values (for example "a", "b", "c")]
primary key: id + fixed_set
I need to use relation like follows:
LEFT JOIN t2 ON (t1.t2_id = t2.id AND t2.fixed_set = "a")
There is followed text in phpdoc from Relation.php:
- local the local field(s)
- foreign the foreign reference field(s)
But it is unable to use several fields in "local" and "foreign", only one "local" and "foreign" field.