<< I got an error message stating I could not have the destination table as part of the FROM clause. Any suggestions would be appreciated. >>
Yes, R:Base does have this limitation on the INSERT statement. However, the similar APPEND statement does not have the same issue. If your columns are named the same in OrderDetail and PRODUCT_NEW then you can use APPEND instead of INSERT and include the additional criteria in your WHERE clause. Otherwise, the way I handle this is to throw the PRODUCT_NEW records into a temporary table and check against _that_ table instead of the original. -- Larry
