Actually, let me see if I can make this clearer.

Table A has fields: add_date, add_time, add_user

Table B does not!

I am updating Table A with Table B, therefore I am scattering from Table B and gathering to Table A. It seems to me that because those fields don't exist in Table B, when it gathers to Table A - it deletes the value of those fields and updates with nothing ( cause those fields don't exist in Table B ). Maybe that makes more sense. I can't really use the GATHER EXPECT add_date, add_time, add_user because they are in Table B. Or if I do that, will it just ignore those records all together?

JOlene