Join Tables On

The query() function is executed on a data source connected to MindsDB and saved into a variable. It performs a join operation between tables.

Syntax and Example

CopyProject mindsdb = server.getProject();
Database maria  = server.getDatabase("mariadb");
maria.query('SELECT * FROM my_table t JOIN another_table a ON t…=a… LIMIT 100')