SQL Duplicates ?
From: Boscia <rwboscia_at_worldnet.att.net>
Date: Mon, 13 Nov 2000 03:40:50 GMT
Message-ID: <B634B0E6.890B%rwboscia_at_worldnet.att.net>
Date: Mon, 13 Nov 2000 03:40:50 GMT
Message-ID: <B634B0E6.890B%rwboscia_at_worldnet.att.net>
[Quoted] I am a newbie when it comes to SQL, so I am not sure how to obtain the following.....
I have a table that has customer telephone numbers in it and a table that
has ticket #'s in it.
I want to do a query that shows all the ticket #'s that have referenced
[Quoted] [Quoted] duplicate telephone numbers. This is how I want to output to appear....
Telephone Number Ticket #
123-456-7890 1234
1235
1236
Count 3 duplicates
for TN 123-456-7890
TN Ticket #
222-333-4568 2345
2346
9034
0932
Count 4 duplicates
for TN 222-333-4568
I am sure this is probably very simple to do, but I do not have a clue..... [Quoted] Thank you...
Robin Received on Mon Nov 13 2000 - 04:40:50 CET