>I have a print file which is created by selecting addresses from multiple database files. Thereby, the same names may be selected
>
>Is there a simple way to command to filter the file for unique names?
>I know I can sort and then compare records but was wondering if there is an easier way.
>
>Thanks
>
>Todd

You might be interested in a unique index on your selection. Another idea is to
SELECT from the first file ;
UNION ;
SELECT from the second file

You can read about the difference between UNION and UNION ALL.