All Products
Search
Document Center

Tablestore:How do I query joined tables?

Last Updated:Jan 09, 2024

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:

  1. Create a mapping relationship between the two tables from which you want to query data. For more information, see Create mapping tables for tables.

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