At 02:54 PM 7/3/2002, Joel Canfield wrote: >I have a table with three columns, ID, IDF, and IDT. All are integers. No >number should be repeated in any particular column, although a number could >conceivably appear in both IDF and IDT. I've added unique constraints, but >if I recall correctly, when we realized that uniqueness was required, >someone foolishly decided to add the constraint with no check on the >existing data. > >I'm trying to come up with a query which would simply list all entries which >appear in any particular column more than once. I'm stumped. It should be >simple, I thought. Select ID From TableName WHERE ID in (Select IDF from TableName) Select ID From TableName WHERE ID in (Select IDT from TableName) Or something like that. -- Anthony Baratta President Keyboard Jockeys "Conformity is the refuge of the unimaginative."