MindsDB home page
Search...
⌘K
Ask AI
Login
Get Started
Get Started
Search...
Navigation
Tables, Views, Files
Join Tables On
Documentation
SQL API
SDKs
REST API
Integrations
Contribute
FAQs
Join our Slack
GitHub
SDKs
Overview
Mongo-QL
Python SDK
Connect
Databases
ML Engines
Projects
Models
Predictions
Tables, Views, Files
Create a Table
Remove a Table
Query a Table
Native Queries
Update a Table
Insert Into a Table
Join Tables On
Delete From a Table
Create a View
Remove a View
Query a View
List Views
Upload a File
Remove a File
Query a File
Jobs
JavaScript SDK
On this page
Description
Syntax
Tables, Views, Files
Join Tables On
Description
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
Here is the syntax:
Copy
Ask AI
my_data_source
.
query
(
'SELECT * FROM my_table t JOIN another_table a ON t…=a… LIMIT 100'
)
Suggest edits
Raise issue
Insert Into a Table
Delete From a Table
Assistant
Responses are generated using AI and may contain mistakes.