<< 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? >>
You have three options: 1. The DELETE DUPLICATE FROM LaborBilled command. This command will go through your table and delete the extra copies for any rows that are really, truly, absolutely dupcicates (exact same value in every single column). If you have any NULL values in any column, you need to do SET EQNULL ON before you run this command, or the duplicates will not be found. Two issues: Sometimes rows that you think are duplicates are not really duplicates (different spelling or extras spaces in a TEXT or NOTE field) and if the table has a lot of rows the command can run for a long time. 2. DELETE FROM LaborBilled WHERE job = 'BE9124' AND EID = '9137' AND LIMIT = 1. This will restrict the command to operate on only the first matching row. 3. EDIT * FROM LaborBilled WHERE job = 'BE9124' AND EID = '9137' and then hitting F9 to delete one of the rows. -- Larry
