On 2014-02-18 11:52, [email protected] 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]
