The JOIN clause of the SQL query feature of Tablestore can be used to join two tables. To query joined tables, perform the following steps:
Create a mapping relationship between the two tables from which you want to query data. For more information, see Create mapping tables for tables.
Use a JOIN clause in a SELECT statement to query data from the two tables. For more information, see Query data and Join.
The following join types are available for join queries: INNER JOIN, LEFT OUTER JOIN, RIGHT OUTER JOIN, and CROSS JOIN.