anders2002
MIS
Hi,
Is it possible to run a simple query that will return entries in a table that are NOT distinct? Like:
Select !distinct from categoryassocs
The table contacts ID1 and ID2 and I need to know where there are duplicates?
Any ideas?
Thanks,
Anderz
Is it possible to run a simple query that will return entries in a table that are NOT distinct? Like:
Select !distinct from categoryassocs
The table contacts ID1 and ID2 and I need to know where there are duplicates?
Any ideas?
Thanks,
Anderz