Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 

  • How to use Right Join on two tables

    @suresh.ramola
    Recommendations Offline Message

    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 472
    Comment on it

    Right Join:

    Right Join is used to join two tables and it return all rows from right table(table 2) and matching rows from table 1(left table). The result is NULL for unmatched rows for table 1(left table). Right Join keyword is used to apply Right Join on two tables.

    Syntax for Right Join:

    1. SELECT columnname(s)
    2. FROM tablename1
    3. RIGHT JOIN tablename2
    4. ON tablename1.columnname=tablename2.columnname;

    In the above syntax there is a column taken from both table on which Right join is applied and this column must be same in both tables.

    Example of Right Join:

    Employee Table:

    1.  EmpID          EmpName              City  
    2. -----------------------------------------
    3.   1             Akhil            Haridwar 
    4.   2             Shilpi           Dehradun   
    5.   3             Neha             Selaqui      
    6.   4             Rohit            Rajpur   
    7.   5             Harshit          Rishikesh

    Department Table:

    1.  EmpID          Department            Salary  
    2.     -----------------------------------------
    3.      1               PHP                 15000
    4.      2               HTML                10000
    5.      3               PHP                 15000
    6.      4               ActionScript        18000

    As we have two tables Employee table and department table and we are applying Right join on it using EmpID column.

    1.  SELECT  EmpID, EmpName, Department, Salary
    2.  FROM EMPLOYEE
    3.  RIGHT JOIN Department
    4.  ON EMPLOYEE.EmpID = Department.EmpID;

    Output for the above query will be like this:

    1.  EmpID           EmpName            Department            Salary  
    2. ----------------------------------------------------------------------------
    3.    1               Akhil               PHP                 15000
    4.    2               Shilpi              HTML                10000
    5.    3               Neha                PHP                 15000
    6.    4               Rohit               ActionScript        18000
    SQL Oracle mysql
    Comment on it

 0 Comment(s)

Sign In
Forgot Password?
                           OR                           
Create an account !!
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Reset Password
Fill out the form below and reset your password: