Solved: Select a particular value from child table - Page 2

dheerajnagpal · 03-01-2023 04:21 PM

Hi There,

I have the following table structure:

Table Parent (Name, Address, Oldest_Child)

Table Child(Name, Parent_Name[Reference to Parent],age)

I want to populate the parent.oldest_child with the name of the oldest child of the parent. What is the best way to do that?

Steve

@dheerajnagpal wrote:

I want to populate the parent.oldest_child with the name of the oldest child of the parent.

ANY(ORDERBY([Related Childs], [age], true))