Re: Copy Data Question

> 3. select into destinationtable from temptable where
> temptable.primarykey not exists
> ( select destinationtable.primarykey
> from destination table
> );

Richard,

thanks for the lead...

this worked...

select product_number, product_name,
product_description, quality_standard,
product_entry_date --into t_product
from t_temp
where not exists
( select product_number
from t_product
where t_temp.product_number =
t_product.product_number
)
;

i did have to add a where clause in the subselect to
get what i was after.

"select into" appears to work only with a new table.

iow i can't select into t_product since it already
exists.

that leaves me needing to combine t_products and
t_select_into_output_table.

any ideas?

ps - maybe select into can work with existing tables,
but i don't know how.

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com