I need to join 2 tables which don’t have common column.
Hi,
What kind of join do you want? 1 to 1, 1 to n or n to n?
Do you know any mathematical/sql expression to join this tables (i.e. always after comma etc.)?
If yes - you have 2 ways (1:1, 1:n):
1 - add a column with extracted values and join on this query item with second table,
2 - add relationship between tables in FM (don't create any link) and in expression window write join syntax.
Michal