| Description |
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.
|