Re: Help: Oracle "select" statement question!!

Hi,

You can try using NOT EXISTS instead.

select to_char(id)
from table1
where not exists ( select 'x' from table2

                           where table2.column = table1.column)

The above is just an example, You can frame your SQL statement according to your needs.

Regards

N.Prabhakar

John Dixon <jdixon_at_mitre.org> wrote in article <33D68D8D.40C22ADB_at_mitre.org>...
> Hello fellow Oracle people,
>
> I need your assistance.
>
> I am trying to perform the following Oracle statement:
>
> select TO_CHAR(id) from message_data where organization = "org" AND
> TO_CHAR(id) NOT IN (select seen_urls from smartpage_data);
>
> I am trying to search for an occurence substring "id" in the result of
> the "select seen_urls from smartpage_data" statement which returns a
> string. The NOT IN function does not check for occurences of
> substring. It just checks the entire string.
>
> Is there a function or method I can use to serarch for the occurence of
> a substring in the result of a select statement?
>
> Thank You
>
> John Dixon
>
>
  Received on Thu Jul 31 1997 - 00:00:00 CDT