Learning the Natural Join



NATURAL JOIN

Usage: HR Manager to data analyst: Bring me the details of employees and the details of corresponding departments. Data analyst runs below query to fetch the required data.

SELECT * FROM EMPLOYEES NATURAL JOIN DEPARTMENTS;







Comments

Popular posts from this blog

Let's extract STRING!

Let's learn Left Outer Join!

Let's learn Cross Join!