Re: SQL-question

>Can anybody help me? My task is the following -
>I need to select all reference numbers from table QUOTE
>which are not present in table XREF.
>I need the most effective variant.
>
None of your choices is the best variant. The following is:

select REFNUM from QUOTE
MINUS
select REFNUM from XREF;

Definitely the fastest...

-- 
=========================================================
            http://www.li.net/~gsa/index.html
This is my signature file, not part of this mail message.