On Tue, 10 Sep 2024, Christophe Pettus wrote:
If you don't mind taking the time to swap tables, you can always do an INSERT ... SELECT DISTINCT <fields> into a new table, and then swap it with the existing table.
Christophe, I'll make the proj_nbr table the PK then do as you recommend. Thank you, Rich
