The best way to do the following?

[dplove]

I have a table that has the following fields: System, Publisher, Package
name, version.

There is duplicate entries for "Package name" and "Version" (It can also be
a different version for the same package). What I would like to do is create
1 table or query that will list 1 entry of each Package name and each
version. What is the best way to do this?

Thanks

 

[KARL DEWEY]

Use this query.

SELECT YourTable.Package, YourTable.Version
FROM YourTable
GROUP BY YourTable.Package, YourTable.Version;