Using Alias when joining 2 or more tables
Hi,
Is there a way to add alias when joining 2 or more tables?
I am trying to make it look from this:
SELECT
AdventureWorks2012.HumanResources.Department.GroupName AS [Group Name],
AdventureWorks2012.HumanResources.EmployeeDepartmentHistory.EndDate AS [End Date],
AdventureWorks2012.HumanResources.Employee.LoginID,
AdventureWorks2012.HumanResources.Employee.JobTitle
FROM
AdventureWorks2012.HumanResources.Department
INNER JOIN AdventureWorks2012.HumanResources.EmployeeDepartmentHistory ON
AdventureWorks2012.HumanResources.EmployeeDepartmentHistory.DepartmentID =
AdventureWorks2012.HumanResources.Department.DepartmentID
INNER JOIN AdventureWorks2012.HumanResources.Employee ON
AdventureWorks2012.HumanResources.EmployeeDepartmentHistory.BusinessEntityID =
AdventureWorks2012.HumanResources.Employee.BusinessEntityID
To something like this using FlySpeed Query.
SELECT
d.GroupName AS [Group Name],
h.EndDate AS [End Date],
E.LoginID,
E.JobTitle
FROM
AdventureWorks2012.HumanResources.Department d
INNER JOIN AdventureWorks2012.HumanResources.EmployeeDepartmentHistory h ON h.DepartmentID = d.DepartmentID
INNER JOIN AdventureWorks2012.HumanResources.Employee E ON h.BusinessEntityID = E.BusinessEntityID
Regards,
Luis
Sergey,
Thank you for the solution and support.