Combining arrays by common variable

Hi, I have A (100 x 2 double), and B (90 x 2) variable. I want to combine these two by common values in the first column of A, and B, so that I have C, a 90(?) x 3 double, where the first column is the common values of the first columns of A and B, the second column is the values of the second column of A, and the third column is the values of the second values of B. I have tried the union function, but have not managed to get this to work...Any help would be appreciated! Thanks! Sushma

Answer 1

[Walter Roberson]

One way is innerjoin()

Another way is:

[tf, idx] = ismember(A(:,1), B(:,1));
[A(tf,:), B(idx(tf),2)]