Hello, I'm trying to solve a task in Mysql 4:
I have a table rec_id | record_ref | keyword ****************************** 1 | 2| apple
2 | 2|orange
3 | 2|apple
4 | 3|mango
******************************
How can I delete records where pair (record_ref and keyword) are identical? In this case either record #1 or #3, but not both.
Thank you, Lana
_________________________________________________________________
Add photos to your messages with MSN Premium. Get 2 months FREE* http://join.msn.com/?pgmarket=en-ca&page=byoa/prem&xAPID=1994&DI=1034&SU=http://hotmail.com/enca&HL=Market_MSNIS_Taglines
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]