5 Replies Latest reply: Feb 11, 2010 4:09 PM by Jean-Jacques Jesua RSS

    Find the Max & get a related field

    Jean-Jacques Jesua

      Hi,

      My problem is simple but I can't find out a simple solution.

      Suppose I have a table with 3 fields : Country, City , Number of Inhabitants

      I'd like to create a straight table with

      Country,

      Name of the city which as the maximum of inhabitants for a country (or the minimum)

       

      Of course, I don't want to do this in the script.

       

      Thanks for your help

      Jean-Jacques