Back
Query in relationships
I see it better in English, hello, I have two documents where in one of them I store the id of the other, something like a union in SQL, how can I do something like
TypeScript
SELECT * FROM worker, department WHERE worker.id = department.id_worker AND department.id = 5
TL;DR
In this support thread, a developer is asking how to perform a SQL-like query in relationships between two documents. They want to achieve something similar to the SQL query: `SELECT * FROM worker, department WHERE worker.id = department.id_worker AND department.id = 5`. The developer is seeking guidance on how to accomplish this.