Re: exclude multiple rows based on values in one row?

Hi, Jack! I'm a little hazy about what you're asking. Do you mean something like

SELECT t1.*
FROM my_table t1
WHERE t1.some_value !=
  ( SELECT t2.some_value
    FROM my_table t2
    WHERE t2.some_other_value = 'The one I want'   )

.. ?

Good luck,
- Catherine Devlin
http://profiles.yahoo.com/arcticturtle

In article <25c7944d.0305281528.7c48effd_at_posting.google.com>, Jack Silvey <depifster_at_yahoo.com> writes:
>anyone know a good way to exclude multiple related rows based on the
>values in one row?
>
>
>thanks,
>
>Jack

• Posted via NewsOne.Net: Free (anonymous) Usenet News via the Web ----- http://newsone.net/ -- Free reading and anonymous posting to 60,000+ groups NewsOne.Net prohibits users from posting spam. If this or other posts made through NewsOne.Net violate posting guidelines, email abuse_at_newsone.net