<DIV name="wmMessageComp"><BR></DIV>
<BLOCKQUOTE style="PADDING-LEFT: 8px; MARGIN-LEFT: 8px; BORDER-LEFT:
blue 2px solid" name="wmMessageComp">
<div>> 3. select into destinationtable from temptable where<BR>>
temptable.primarykey not exists<BR>> ( select
destinationtable.primarykey<BR>> from destination
table<BR>> ); <BR><BR>Richard, thanks. in my case, the
primary key isn't<BR>relevant, however, the product_number is (it
is<BR>unique). iiuc, in my case i should use
product_number<BR>instead of primarykey.<BR><BR>it makes sense - thanks
for the enlightenment.</div></BLOCKQUOTE>
<P name="wmMessageComp">(slightly off topic) You might consider changing
your table structure so product_number is your primary key, if it always
unique. That way you don't need an additional primary key field. Just a
suggestion.</P>
<P name="wmMessageComp"> </P>