Oninit Logo
The Down System Specialists
+1-913-674-0360
+44-2081-337529
Partnerships Contact
Finderr

-2858 The table table-1 is joined to the table table-2, but its joined

columns do not belong to a composite key.

You have defined two or more different joining columns between the two indicated tables. However, no composite index exists on the joining columns. Such an index is required to ensure that a composite key exists; that is, that any combination of values from the joining columns will occur only once. Review the two or more ATTRIBUTES statements that define join columns for these two tables. Make sure that they are as you intended; for example, make sure that you intended to join two tables on two or more columns, instead of joining three or more tables on one column each. If you intended the composite key, then use the CREATE INDEX command to create a composite unique index on those columns for at least table1.