Re: A query question

From: crappy <crappygolucky_at_hotmail.com>
Date: 7 Jan 2002 10:11:11 -0800
Message-ID: <ce31c410.0201071011.70e94828_at_posting.google.com>


true. i thought the OP was just interested in the name/ssn's that had multiples, and not what the multiples actually were. but you're probably right.

millerjcr_at_hotmail.com (Jason Miller) wrote in message news:<9d5d63c7.0201041417.62ed3c64_at_posting.google.com>...

> That would work for the sample table, but if there were three or more
> different custid's for a ssn/name combination, you'd start to have
> problems. I'm assuming that the sample data was simplified and just
> given as an example. Take the following hypothetical sample table and
> consider what the above SQL code would produce.
>
Received on Mon Jan 07 2002 - 19:11:11 CET

Original text of this message