import java.sql.*;

public class natleftjoin{
  public static void main(String[] args) {
    System.out.println("NATURAL LEFT 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 LEFT JOIN "+"emp_sal");
                 //Natural Left 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();
    }
  }
}