This is machine translation

Translated by Microsoft
Mouseover text to see original. Click the button below to return to the English version of the page.

Note: This page has been translated by MathWorks. Click here to see
To view all translated materials including this page, select Country from the country navigator on the bottom of this page.

Join Tables Using Command Line

You can join data in database tables and import the results interactively by using the Database Explorer app. Or, you can join two database tables by using the sqlinnerjoin and sqlouterjoin command line functions. The following short examples show how to join tables using the command line.

Enter this code to create an inner join between two database tables (the left table and right table of the join). An inner join retrieves records that have matching values in the shared column of both tables.

lefttable = 'productTable';
righttable = 'suppliers';
data = sqlinnerjoin(conn,lefttable,righttable);

To create an outer join, enter this code at the command line. An outer join retrieves the matched and unmatched rows between the two tables. This code shows a right outer join that uses different left and right keys in the corresponding database tables.

lefttable = 'employees';
righttable = 'departments';
data = sqlouterjoin(conn,lefttable,righttable, ...
    'LeftKey','MANAGER_ID','RightKey','DEPT_MANAGER_ID', ...
    'Type','right');

To join more than two database tables at a time, use the Database Explorer app. For details, see Join Tables Using Database Explorer App. Or, you can create and run an SQL script using the executeSQLScript function.

See Also

|

Related Topics