Re: SQL Help with minus..

From: Jerry Gitomer <jgitomer_at_hbsrx.com>
Date: Fri, 20 Aug 1999 09:15:36 -0400
Message-ID: <7pjkvd$gkc$1@autumn.news.rcn.net>

Have you considered?

    INSERT INTO <exceptions_table>
    select rtrim(retailerid)
    from rawedidetail
    minus
    select retailer_id
    from retailer_dim
    ;

regards
Jerry Gitomer

KTL wrote in message <37BC4C23.2D6B1232_at_rs-net.com>...
>select rtrim(retailerid)
>from rawedidetail
>minus
>select retailer_id
>from retailer_dim
>
>I need to move the rows that this query returns from one table
>(rawedidetail) to an exceptions table. I am using a cursor in a
>procedure..
>
>I would like to move the data based on the rowid.. however I do
not know
>how to include the rowid in a minus and have it work!?
>
>Can I use a insert into where select .. not in?
>
>Suggestions?
>
>Thanks for your help..
>
>-Ken
>
Received on Fri Aug 20 1999 - 08:15:36 CDT