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

    Find the Max & get a related field


      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


      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