Page 214 - Informatics_Practices_Fliipbook_Class12
P. 214
Table: Employee
ID FName .............. Dept_No.
10001 Raj 2 Table: Department
10002 Dhiraj 1
10003 Muskan 2 Dept_No Dept_Name Location Mgr_Id
10004 Hiten 4 1 Accounts Noida 10002
10005 Anshul 1 2 Administration Delhi 10005
10006 Rajit 4 3 Home Goods Mumbai 10003
10007 Taran 5 4 Automobile Jamshedpur 10004
10008 Naval 2 5 Textile Mumbai 10007
10009 Naveen 4
10010 Savita 5
Query: SELECT FName, Dept_Name
FROM Employee E, Department D
WHERE E.Dept No=D.Dept_No;
FName Dept_Name Dept_No
Raj Administration 2
Dhiraj Accounts 1
Muskan Administration 2
Hiten Automobile 4
Anshul Account 1
Rajit Automobile 4
Taran Textile 5
Naval Administration 2
Naveen Automobile 4
Savita Textile 5
Figure: Equi-Join
Let us see some more examples of equijoin.
Query: To display the first name, last name and department name of all employees.
Solution:
SELECT FName, LName, Dept_Name
FROM EMPLOYEE AS E, DEPARTMENT AS D
WHERE E.Dept_No = D.Dept_No;
200 Touchpad Informatics Practices-XII

