Hi.
Is it possible to write a join between two collections using wixData.query() function?
And how?
Thanks
Claudio
Have you looked at using reference fields for multiple datasets.
https://support.wix.com/en/article/displaying-content-from-multiple-database-collections-using-reference-fields-4034931
https://support.wix.com/en/article/displaying-content-from-multiple-database-collections-using-reference-fields
https://support.wix.com/en/article/about-connecting-multiple-database-collections
https://support.wix.com/en/article/displaying-content-from-multiple-database-collections-using-datasets
https://www.wix.com/corvid/forum/community-discussion/help-with-querying-referenced-fields%3fpage%3d1%26dl%3d5c33c1c95516de01d29e8d88%252f5c17f9493aeebe016fec021c%252f1
https://www.wix.com/corvid/forum/community-discussion/two-collection-in-same-data-query-on-basis-of-reference-key
https://www.wix.com/corvid/forum/community-discussion/query-database-retrieve-data-to-implement-in-new-query