Relational Join

Relational Join of Two Matrices

Example:
A = [ 3 4 5; 1 2 3; 6 7 8];
B = [ 9 10 11; 3 4 55; 6 7 88];
join(A,1:2,B,1:2)

ans =
3 4 5 55
6 7 8 88

Join options (inner, outer left, right, full) supported

Matlab contains a number of set-oriented function like INTERSECT, UNIQUE, UNION, SETDIFF, SETXOR, ISMEMBER. However, one interesting missing function is something similar to a database-like JOIN. This can be written using above functions, but requires a for-loop which makes it very slow for large datasets.

We supply a C++- mex file and a wrapper matlab function.