Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
albrad84
Starting Member
1 Post |
 Posted - 2008-06-26 : 11:50:51
|
| Here is a simplified version of the problem I have.I have the following 2 tables:contact-id-email-other fields...contact_division-contact_id (foreign key)-division-other fields...I need a query that finds all records that are duplicates in terms of both email and division (but not necessarily the other fields).Thanks in advance! |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-06-26 : 12:34:52
|
| We dont know whether your both table contain duplicates or just one. Can you please provide some sample data from your two tables? |
 |
|
|
|
|
|
Duplicates across 2 tables