Join Tables On

docs/sdks/javascript/join_on.mdx

26.1.0275 B

Description

The runQuery() function executes a query given as its argument directly in MindsDB.

Here is the syntax:

const query = `SELECT * FROM table_name t JOIN another_table a ON t…=a…`;
const queryResult = await MindsDB.SQL.runQuery(query);