Useful QA related to Query table
In this vedio you will see how to Create Query Table data using Join in Zoho Analytics using Sql Query and Create Report using this table. Query Table is a feature that enables you to prepare data for easy reporting and analysis. You can combine data from one or more tables in a Workspace and create specific data views using the standard SQL SELECT queries. These data views are similar to tables and you can perform operations such as report creation and sharing.
You can create it for filtering datasets, batching datasets together (union), transforming data, applying SQL query functions, joining datasets and more.
Q. What are the SQL dialects supported in this?
Zoho Analytics currently supports SQL SELECT queries written in ANSI, Oracle, SQL Server, IBM DB2, MySQL, Sybase, Informix and PostgreSQL SQL dialects.
Although we support all of the above-mentioned dialects, we recommend you to use the ANSI SQL dialect for better coverage and support.
Q. What is SQL SELECT command and how is it used in Zoho Analytics?
SQL (Structured Query Language) is a standard and popular language for storing, manipulating and retrieving data in databases (eg., Oracle, SQL Server, MySQL etc.,).
Zoho Analytics uses the SQL “SELECT” statement for creating a Query Table. The SELECT statement helps to select data from the tables. A simple SQL SELECT query looks as shown below:
SELECT Customer Name, City FROM Customers;
This query fetches the Customer Name and City from the table Customers.
Q. Can I join one or more tables using a Query Table?
Yes, you can. But, we strongly recommend you use the Auto-Join feature in case you wish to join (combine) two or more tables. This feature automatically joins tables when creating reports, if the tables are connected using a Lookup column.
If you would still prefer to use a Query Table to join tables, you can do so. Zoho Analytics supports the following joins: Left Join, Right Join and Inner Join.
This explains that how the data is combine in all three join types when you join the column DepName from the Department Table along with the columns Emp_Name, Joining_Date from the Employee table.
