Joining on Multiple fields

[rsdhavle]

If there is no specific primary key in two tables and we need to join on more that one fields how that scenario can be handled?

What is the proper way of data modeling in such case.

[Anonymous]

you need to identify key columns (aka composite key) in both tables

[MK_QSL]

Can you provide little example on your requirement?

Joining of more than one field can be done by

Field1 & '|' & Field2 & '|' & Field3  as %Key