G'day Damon,
DELETE DUPLICATES FROM tablename will do the trick - the help file will have more details Regards Clive Williams From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Gray, Damon Sent: Friday, 21 November 2008 10:12 To: RBASE-L Mailing List Subject: [RBASE-L] - delete rows I apologize for the extreme ignorance that shows up in my questions, but I am still on a steep learning curve with this tool. I have a couple of rows in a table that are identical in every respect. It is a double entry, and one of them needs to go away, but I don't see anything that uniquely identifies one row from the other. There has to be, but I cannot see it. Is there a hidden primary key somewhere? I can't do a delete from laborbilled where job = 'BE9124' and EID = '9137' because that will delete both rows. Does my question even make sense? Damon J. Gray Anvil Corporation Business Services (360) 937-0770 __________ Information from ESET Smart Security, version of virus signature database 3628 (20081120) __________ The message was checked by ESET Smart Security. http://www.eset.com
