How do I select distinct on one column and return all other columns?
Some SQL databases let you do something like:

SELECT
  DISTINCT ON(Version)
  FirstName, LastName
  /* INTO NewTable */
FROM
  Table ;


This "DISTINCT ON(x)" is implemented only by a limited number of databases. I don't think it is implemented by "Access", and I would think that most probably is not implemented by the "dBase IV" interface. 

The SQL used by Access (don't know if the dBase IV variant will work) might let you do something equivalent:

SELECT
    Version, first(FirstName) AS FirstName, first(LastName) AS LastName
FROM
    (SELECT 
       * 
    FROM 
         TableName
    ORDER BY
          Version  /* and whichever columns make sense for your purpose */
    ) AS OrderedTable
GROUP BY
    Version ;


First is an aggregate function, that, together with GROUP BY, will make sure that you get one value for each group. This value will be the "first one found for the group", so you need to order first your table in a sensible way.

If none of these forms work... My guess is that you will have to solve the problem outside of SQL, getting a RecordSet into your program, looping checking, and inserting into NewTable.