On 2014-02-18 11:52, jim.rhema316@... wrote:

> merge into tableA e
> using tableB s
> on (e.field1 = s.field2)
> when not matched then insert (ACTION,ITEMID,TITLE,SITEID,CURRENCY,STARTPRICE,BUYITNOWPRICE,QUANTITY,RELATIONSHIP,RELATIONSHIPDETAILS,CUSTOMLABEL,MATCHED,VENDOR)
> values ('End',e.ITEMID, e.TITLE,e.SITEID,e.CURRENCY,e.STARTPRICE,e.BUYITNOWPRICE,e.QUANTITY,e.RELATIONSHIP,e.RELATIONSHIPDETAILS,e.CUSTOMLABEL,'N','Sullivans');
>
> What I am trying to accomplish is if there isn't a match I need to insert a record into tableA because tableA will be an input table into a subsequent process and the data I need is only on tableA.

Since it looks to me like you are inserting into tableA with records
from tableB, shouldn't the VALUES() listed be from tableB?

Cheers!
Rich Saunders


[Non-text portions of this message have been removed]