Can we use more than 2 tables in Select Operation for a DB call in OIC?

Summary:

Ex: Table 1 has a primary key P1, Table 2 has a primary key P2 and there are two other columns (P3,P4) present in both the tables but these columns are not defined as any constraint. So how can we extract data from these two tables using select operation in OIC. As OIC allows to define relationship based on primary keys only.

Content (required):

Ex: Table 1 has a primary key P1, Table 2 has a primary key P2 and there are two other columns (P3,P4) present in both the tables but these columns are not defined as any constraint. So how can we extract data from these two tables using select operation in OIC. As OIC allows to define relationship based on primary keys only.