SQL query statement to find duplicate records in a database table. SELECT fieldname1, fieldname2, COUNT(duplicatefieldname) FROM tablename GROUP BY duplicatefieldname HAVING COUNT(duplicatefieldname)
A simple statement to update one table field with another table field value. UPDATE theUpdateTable INNER JOIN theValueTable ON (theUpdateTable.matchValueField =theValueTable.matchValueField) SETtheUpdateTable.valueToUpdate