Results 1 to 2 of 2

Thread: Return max value w/ data

  1. #1
    Join Date
    Nov 2006

    Return max value w/ data


    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
    Attached Images Attached Images

  2. #2
    Join Date
    Nov 2006
    Problem solved.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
HTML5 Development Center

Recent Articles