What are Query Tables and How Do They Work?
A Query Table is the Zoho Analytics, in-house SQL editor. It allows you to use SQL (stands for “Structured Query Language”) with any existing table in Analytics. Those tables could come from CRM, Books, or a third-party app or database.
If you have taken any of our CRM or other Analytics courses, you understand the idea of lookup relationships. Those allow us to create charts or pivot tables on top of the data from multiple tables. SQL essentially does the same.
In this first lesson, we introduce the Query Table editor and some SQL principles. Then, in the second lesson, we dive deeper into SQL architecture and talk about joining tables, filtering, and more.