I also have no qualms about using Append. The one advantage over Insert is
that you can use the same table in the sub-select clause. IE: you cannot do:
insert into customers (custid) select custid from temptable where custid
not in (select custid from customers)
But you can do:
append temptable to customers where custid not in (sel custid from
customers)
Karen
> Tom
> I am happy to use append
> It works fine within R:Base (the only db you really want to use)
> But if you are required to work with foreihg DB, then you better stick to
> INSERT, since that is working both with R:Base and foreign DB.
> I understand INSERT to be SQL standard and append to be R:BASE specific!
> If I create a new program I use insert but I am happy to keep my R:Base
> append code!
>
>
