How to inner join two matrices?

I have following two matrices of data that contain three columns each, first two columns are GPS data (latitude, longitude) and the third value is elevation angle. I would like to inner join both tables based on their GPS values to calculate the difference in elevation angle between the two matrices. Here is an example;

tbl1 = [
   28.057      -80.621        25.3 
    ......];
tbl2 = [
     28.057      -80.624        20.6
     28.057      -80.621       20.62
     .....];

tbl3 should look like the following:

tbl3 = [
28.057      -80.621        25.3      20.6   4.7];

Any idea on how to join these tables? Cheers!

Answer 1

[Guillaume]

[~, row1, row2] = intersect(tbl1(:, [1 2]), tbl2(:, [1 2]), 'rows');
tbl3 = [tbl1(row1), tbl2(row2, 3)];
tbl3(:, 5) = diff(tbl3(:, [4 3]), [], 2);

This assumes that the GPS values are exactly identical in both matrices or that they're rounded to the same number of decimals in both.

[Mohammed]

Appreciate your contribution and thanks! Just a quick note on the last line, I had to update it to the following since I wasn't able to get results with "diff" command and here is the Error: "Subscripted assignment dimension mismatch." Do you have an idea Why?

 tbl3(:, 5) = tbl3(:,3) - tbl3(:,4);

[Guillaume]

Sorry, forgot to specify the dimension in diff (and got the wrong column destination). It should have read:

tbl3(:, 5) = diff(tbl3(:, [4 3]), [], 2);

Fixed now.

[Mohammed]

Works like charm, however it is missing single parenthesis :). thanks again for sharing your knowledge.

tbl3(:, 5) = diff(tbl3(:, [4 3]), [], 2);