SQL Query Example

For the Account SQL Query and Group SQL Query fields, see the following Join Query example:

The Employee.csv file has the following columns:

  • ID

  • FullName

  • Email

  • ContactNo

The EmpDept.csv file has the following columns:

  • ID

  • DeptNam

  • Role

To aggregate data from Employee.csv and EmpDept.csv, the JOIN query would be as follows:

Copy 
select e.ID, e.FullName, e.Email, e.ContactNo, d.DeptName, d.Role
from Employee e , EmpDept d
where e.ID=d.ID

Note
When the file name is Employee.csv in the SQL query, you must mention only "Employee"; the ".csv" file extension is not required.