>I'm trying to select out from a parent table to a child table. The child can have multiple entries but I want to return the line with the largest value. I've tried a couple of select combinations but I'm not getting the correct result
>
>PARENT
>1 Name1
>2 Name2
>3 Name3
>
>CHILD
>1 12 Code1
>2 19 Code2
>2 16 Code3
>3 10 Code4
>3 13 Code5
>
>I want the result to be
>Name1 Code1
>Name2 Code2
>Name3 Code5
>
>~M

ignore