Can we Make a Forced Join on two Tables

[#1]

I have a situation where I have two tables, and we should not have a common element in both the tables, as the results are ambiguous when we have the ID's as Common. However in one calculation I need to check the common rows for which I need to join them, can we Impose a forced Join on two tables with different names.

Ex:   A.EmployeeID = B.EmployeeID

[rbecher]

Hi,

I think this can work only in the load script:

JOIN(A) LOAD B.EmployeeID as A.EmployeeID Resident B;

- Ralf

[#3]

Thanks Ralf,

I tried this, yes it work only in the script level.