Inner join between two MySQL database tables
returns a table resulting from an inner join between the left and right database tables.
This function matches rows using all shared columns, or keys, in both database tables. The
inner join retains only the rows that match between the two tables. Executing this function
is the equivalent of writing the SQL statement data
= sqlinnerjoin(conn
,lefttable
,righttable
)SELECT * FROM lefttable,righttable
INNER JOIN lefttable.key = righttable.key
.
uses additional options specified by one or more name-value pair arguments. For example,
data
= sqlinnerjoin(conn
,lefttable
,righttable
,Name,Value
)'Keys','productNumber'
specifies using the
productNumber
column as a key for joining the two database
tables.
The name-value pair argument 'VariableNamingRule'
has these limitations
when it is set to the value 'modify'
.
The variable names Properties
, RowNames
, and
VariableNames
are reserved identifiers for the
table
data type.
The length of each variable name must be less than the number returned by namelengthmax
.