This section describes the NATURAL LEFT JOIN operation and how to retrieve data through it. In this operation we are going to retrieve data according to match the field name of another tables.
NATURAL LEFT JOIN: In this operation both tables are merged to each other according to common fields but the priority is given to the first table in database.
Description of program:
In this program we are going to establish the connection with MySQL database by using the JDBC driver, after that we will join two tables through the help of NATURAL LEFT JOIN operation. It retrieves data on the specific field name that matches in both tables.
Description of code:
SELECT *FROM employee NATURAL LEFT JOIN Emp_sal:
Above code retrieves all data that matches in both tables on the basis of Emp_name field.
Here is the code of program:
Output of program:
Natural Left Join Tables Example!
Emp_name Emp_ed Emp_sal
santosh 2 4500
deepak 10 0
Aman 13 8000
If you enjoyed this post then why not add us on Google+? Add us to your Circles
Liked it! Share this Tutorial
Discuss: Join tables with the NATURAL LEFT JOIN operation
View All Comments
Post your Comment