Subject | SQL to find duplicate values |
---|---|
Author | Clay Shannon |
Post date | 2005-02-18T14:46:46Z |
Who has the SQL at hand to show records in a table that have column values
in common. I ported an Access DB to FB and want to make sure that I don't
have
duplicate FirstName/LastName values in one of the tables (which, if were
true, would have different ID values-one person would actually be multiple
people, as far as the DB was concerned).
Clay Shannon,
Dimension 4 Software
[Non-text portions of this message have been removed]
in common. I ported an Access DB to FB and want to make sure that I don't
have
duplicate FirstName/LastName values in one of the tables (which, if were
true, would have different ID values-one person would actually be multiple
people, as far as the DB was concerned).
Clay Shannon,
Dimension 4 Software
[Non-text portions of this message have been removed]