INNER JOIN with Examples - SQL Query

Consider the following tables.

Table1: Employee

EmpIDEmailIDPhone
1rajeev@gmail.com987654321
2sonam@gmail.com984454378
3anil@hotmail.com887899644
4keshav@yahoo.com789987461

Table2: EmpSalary

EmpCodeSalary
1232000
45625000
79818000
32115000

Table3: EmpInfo

EmpIDEmpCodeEmpFirstNameEmpLastName
1123RajeevSharma
2456SonamGupta
3789AnilMathur
4321KeshavVerma

Q. Perform INNER JOIN to display columns Such as EmpID, EmpFirstName, EmpLastName, Salary, EmailID, Phone.

Answer:

SELECT A.EmpID, A.EmpFirstName, A.EmpLastName, B.Salary, C.EmailID, C.Phone
FROM Employee A
INNER JOIN EmpSalary B ON A.EmpCode = B.EmpCode
INNER JOIN EmpInfo C ON A.EmpID = C.EmpID


In the above query, 'A', 'B', 'C' are used as Alias.

Output:

EmpIDEmpFirstNameEmpLastNameSalaryEmailIDPhone
1RajeevSharma20000rajeev@gmail.com987654321
2SonamGupta25000sonam@gmail.com984454378
3AnilMathur18000anil@hotmail.com887899644
4KeshavVerma15000keshav@yahoo.com789987461
▲