Re: Query help needed

From: Ed prochak <ed.prochak_at_magicinterface.com>
Date: 11 May 2004 10:46:18 -0700
Message-ID: <4b5394b2.0405110946.3d6b1afa@posting.google.com>

peteg_at_garlic.com (hedrew3) wrote in message news:<aad10be0.0405101414.3e0f9a39_at_posting.google.com>...
> I have a table X with columns contract_number and support_number. I am
> trying to query for the contract_numbers that have more than one
> DIFFERENT support_numbers associated with it.
>
> TIA
>
> Pete

Consider rephrasing your question using DISTINCT instead of DIFFERENT.

HTH,
ed

Remember the book's index is your friend. And even more true for ORACLE manuals. Received on Tue May 11 2004 - 12:46:18 CDT