Are there a way we know what class can be join with other? For example i have: Data-Admin-Operator-ID class and I want to know what is other class can be joined with it in Data Access Tab of Report definition.
Joins allows us to combine data from 2 or more classes with common Primary-Foreign Key data. I dont think of any limitation on classes you can join until the time you have common identifiers in both tables. Hope this helps
Joining can be done only when the multiple tables have some common identifiers, like primary key in one table should be available as a foreign key in other table, Without the relation joining is never possible. While designing Entity relationship these things to be considered for related tables.