how can i find records with duplicate entries in their first two fields Results


1. How can I find records with duplicate entries in their first two fields?

Sponsored Links:



Say I have a table with the following fields..

A | B | C | D | E | F

What I want to do is the following..

Find and display all rows in which the fields A and B are the same. It dosent matter to me what entries are in C, D, E, and F.

So if one entry was

hoover | Frank | foo | bar | etc..

it would match up with

hoover | Frank | khrkh | something | anything


Should be easy to do but I can't figure it out! Please help!!