Re: NOT IN

colmkav wrote:
> is it possible to write an SQL Oracle query where you want to check
> whether a combination of fields exist in another query
>
> eg I tried the following but got an error:
>
> select count(*) from tmp_risk_sum where book, strategy, exposuretypeid
> not in (select book, strategy, exposuretypeid from tmp_risk_sum_ORACLE)

Did you try it? What happened?

For examples of similar queries go to Morgan's Library at www.psoug.org and scroll down to SELECT statements.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org