jointable

Join pairs of tables using arbitrary keys

usage: jointable(tab1,tab2,keys1,keys2,fillval)

JOINTABLE works much like an SQL join, where each row of the join corresponds to rows of the tables with matching keys. Positions corresponding to non-matching keys are filled with the specified value.

Examples:

jointable([1;2;3],[4;5],{'a','b','c'},{'a','b'}) % join on string keys
jointable({'a';'b';'c'},{'d';'e'},[1,2,3],[1,2]) % join on numeric keys
jointable([1;2;3],[4;5],ones(1,3),ones(1,2)) % join on non-unique keys

The treatment of non-unique keys differs from that of an SQL full outer join.

NOTE: Requires LEXCMP (see below).

See the help for more details.