Natural right join

This section contains the detail about the Natural right join in java.

Natural right join

n Natural Right join, both table are merge to each other according to common field, but the priority is given to the Second table's field values  means a Right join returns all the values from the right table and matched values from the left table (NULL in case of no matching join predicate).

In Right join, every row of left table appears at least once in joined table, If no matching row from the "Left" table exists, NULL will appear in columns from Left Table for those records that have no match in Right Table.

Query for Right Join

SELECT *FROM employee NATURAL RIGHT JOIN Emp_sal

The two tables before Right join --

"employee" table   

 "emp_sal" table

natrightjoin.java

import java.sql.*;

public class natrightjoin{
public static void main(String[] args) {
System.out.println("NATURAL RIGHT JOIN");
Connection con = null;
try{
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection("jdbc:mysql://192.168.10.13:3306/ankdb","root","root");
try{
Statement st = con.createStatement();
ResultSet res = st.executeQuery("SELECT *FROM "+"employee"+" NATURAL RIGHT JOIN "+"emp_sal"); 
//Natural Right Join two tables
System.out.println("Emp_code" + "\t" + "Emp_name" + "\t" + "Emp_salary"+"\t"+"Emp_designation");
while(res.next()){
int code = res.getInt("Emp_code");
String name = res.getString("Emp_name");
String sal = res.getString("Emp_salary");
String post = res.getString("Emp_designation");

System.out.println(code + "\t\t" + name + "\t\t" + sal+"\t\t"+post);
}
}
catch (SQLException s){
System.out.println("SQL statement is not executed!");
}
}
catch (Exception e){
e.printStackTrace();
}
}
}

Output :

Download Source Code