Skip to content
Advertisement

How to Select one Value for each row after Joining of 2 Tables

I have 2 tables, the first one has 10 distinct values:

First Table,

each GlobalPnID has many values on the second table, I want to join 2 tables and select one random value of PortionKey of the second table that match the condition and move to the next GlobalPnID

enter image description here

Advertisement

Answer

User contributions licensed under: CC BY-SA
5 People found this is helpful
Advertisement