Last record from another table in virtual column

Apper
Participant II

Hi Guys!
After reading a lot and trying different expressions I’ve got stuck!

Would someone be able to help me out with next problem?

I have Table_1 where I’d like to create virtual column, which would return the last value of the Column 3 from Table_2 if the Column_1 from Table_1 is matching Column_1 from Table_2. Also I cannot make the Column_1 in Table_2 the key value as it repeats its value throughout the table many times, so I have to use there UNIQUEID() key.

Many thanks!

Solved Solved
0 2 335
1 ACCEPTED SOLUTION

Lynn
Participant V
2 REPLIES 2

Lynn
Participant V

Last link helped solved my problem.

Thank you so much!

Top Labels in this Space