Append ORDERDETAIL to PRODUCT_NEW where +
Model# not in (Select Model# from PRODUCT_NEW) Append allows the destination table in the where clause. -Bob ----- Original Message ----- From: "Jim Belisle" <[email protected]> To: "RBASE-L Mailing List" <[email protected]> Sent: Monday, April 6, 2009 4:21:53 PM GMT -06:00 US/Canada Central Subject: [RBASE-L] - insert needed item into table I created the below EEP on field exit (field MODEL#) so new items get inserted into a special table so I can format the product later. This is used for quoting purposes. We sometimes have custom quotes on existing items that get “tweaked” a little for the customer. Insert into PRODUCT_NEW select CONTROL#,MODEL + from ORDERDETAIL where + MODEL# not in (select MODEL# from PRODUCT) RETURN The EEP does insert new items into the new table but the problem is I want to be able to also make sure the new items are not already in the PRODUCT_NEW table in case I have not been able to format the items before the next entry. I tried that with: MODEL# not in (select MODEL# from PRODUCT_NEW). I got an error message stating I could not have the destination table as part of the FROM clause. Any suggestions would be appreciated. Jim
