Take all cells values from another tables

[ChrisNZ]

Note that when doing the merge

  merge TABLE2
        TABLE(in=Y);

you are matching one to one, so the shortest table (in terms of number of observations) stops the processing even if the other one is longer.