• monzulu (6/24/2010)


    i want to copy the contents of table1 to table2 and "prune" table1 with only 1 occurence of each place.

    .....

    thanks for any advice and suggestions.

    SELECT ...UNION... also can be used to achieve this.