Outputting duplicate files

[cwalshe]

Hi there,

I wish to write a queries that will find all enrties that are duplicates.

EG filename Filepath Size
xyz c:\nydata 12
xyz a:\stuff 8
xyz c:\nydata 12

I would like to return :
EG filename Filepath Size
xyz c:\nydata 12
xyz c:\nydata 12

Therefore I think that I am looking for a statement like: select * from my table where filepath is the same

Any ideas...

Cormac.

 

[Maquis]

Use the "Find duplicates query" wizard. It sounds like just what you need. Maq B-)
<insert witty signature here>