Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
you need to identify key columns (aka composite key) in both tables
Can you provide little example on your requirement?
Joining of more than one field can be done by
Field1 & '|' & Field2 & '|' & Field3 as %Key