Last record from another table in virtual column

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!

4 Likes

Last link helped solved my problem.

Thank you so much!

2 Likes