I am trying to retrieve the MAX(BigFish) from the BIGFISH table, the FIRSTNAME , LASTNAME and COUNTRY from the FISHANGLER TABLE and the FISHFILE and FISH from the FISH TABLE.
I am able to return the correct information from the BIGFISH and FISHANGLER tables, but cannot return the correct FISHFILE and FISH data from the FISH TABLE. There are several rows of data in the FISH TABLE in relation to the FISHANGLER.
Attached are the images of the columns circled
Image 1 - BIGFISH Table
Image 2 - FISH Table
Image 3 - FISHANGLER Table