www.webdeveloper.com
Results 1 to 2 of 2

Thread: Return max value w/ data

  1. #1
    Join Date
    Nov 2006
    Posts
    231

    Return max value w/ data

    Gang,

    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
    Posts
    231
    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