MySQL 4.0.14
In a scenario: Ref EmailAddr ---------------- 1 [EMAIL PROTECTED] 2 [EMAIL PROTECTED] 3 [EMAIL PROTECTED] 4 [EMAIL PROTECTED] how can I delete duplicate email entries (records 1, 2) leaving 4. regards ___________________________________________________________ALL-NEW Yahoo! Messenger - all new features - even more fun! http://uk.messenger.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]