Yeah I know.... but my higher ups would never understand that... it's a pain.

But I think I found a solution..... building off the delete approach:

DELETE FROM outgoing_voice

WHERE sub_id NOT...

Whoops.... Actually that will obviously delete all numbers that have more than one. How can I adjust that delete query to delete all but one number???

Thanks!!!!

Thank you for responding!!!

Sorry for not providing the needed information. I would have but it is very sensitive and by the time I would be authorized to provide the...