SELECT column_name1 AS alias_name,
column_name2 AS alias_name,...
FROM table_name;
SELECT alias_name.column_name,alias_name.column_name, alias_name.column_name
FROM FirstTable AS alias_name, SecondTable AS alias_name
WHERE alias_name.CommonFirstTableColumn = 'ColumnValue' and alias_name.CommonSecondtableColumn = ColumnValue’
SELECT d.DepartmentName,e.Name,e.Age,e.Email,e.Salary,e.PhoneNumber
FROM Department AS d, Employee AS e
WHERE d.ID = '1' and e.DepId = '1'
SELECT d.DepartmentName,e.Salary as Total_Production_Deparment_Salery