Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2014
    Posts
    1

    No idea where to post this question :)

    Good morning! I just signed up in this forum to get some help with this. But I am not sure where to post it.

    How can I get from this table:

    Name | City
    Llucia | Boston
    Llucia |
    Jackie | New York
    Jackie |

    To this:

    Name | City
    Llucia | Boston
    Jackie | New York


    Using calc, base or a SQL statement?

    Thank you!

    Thank you!

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    You could get there using SQL by:
    Code:
    SELECT Name, Max(City) AS City
       FROM daTable
       GROUP BY Name
    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

Posting Permissions

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