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
   209   210   211   212   213   214   215   216   217   218   219