It is used to select the required data from the. In this short tutorial you have seen how the COUNTGROUP BYJOIN combination can be used in SQL to aggregate entries across multiple tables. Sql Join Dofactory Lets rearrange the previous query. . Employees2 SELECT DeptID MAXSalary AS DeptMaxSalary FROM employees GROUP. The only difference between these two SQL JOIN types is the table from which the records are taken regardless of the JOIN condition. Ks Late person1 1 person2 1 And I want to join the results of these two select statements by the KS Im trying to avoid using a temp table but if thats the only practical way to do this Id like to know more about using temp tables in this fashion. SELECT eId eFirstName eLastName eDesignation eCity epProjectId FROM Employee AS e INNER JOIN EmployeeProject AS ep ON eId epEmployeeId. Lets think of the above table as Employee-EmployeeProject. CREATE TABLE employee ID int. ...