Hi Naomi Thanks for replying.
So if I have
Source table as: FLDS_1 FLDS_2 FLDS_3
Destination Table as: FLDD_1 FLDD_2 FLDD_3

The names of the fields I require in the Output Into table are:

FLDS_1 FLDS_2 FLDS_3
FLDD_1 FLDD_2 FLDD_3

I.E. A L L the fields from both the input and output tables with exactly the same names ???

Regards,
Gerard



>>Hi
>>
>>If I use a SQL Merge with an Output Clause, If I dont specify an INTO, it works fine
>>However, If I use an INTO clause , it errors with a 'Column Name or number of supplied values does not match table...
>>
>>I cant seem to get the Column Names correct in the output table
>>
>>1. Does it matter what they are called
>>2. Do they have to be same as source
>>3. Do they have to be same as source with an old_ and a new_ prefixed
>>4. Does the Type matter
>>
>>I just cannot seem to get the column names correct
>>
>>Tia
>>Gerard
>
>Define your output table the same or similar as your source and target and explicitly list columns in the OUTPUT clause, don't use *