Warning: include(../file/sql-sidebar-nav.php): failed to open stream: No such file or directory in /home/java8s/public_html/oracle/sql/sql_equi_join.php on line 50

Warning: include(../file/sql-sidebar-nav.php): failed to open stream: No such file or directory in /home/java8s/public_html/oracle/sql/sql_equi_join.php on line 50

Warning: include(): Failed opening '../file/sql-sidebar-nav.php' for inclusion (include_path='.:/opt/cpanel/ea-php56/root/usr/share/pear') in /home/java8s/public_html/oracle/sql/sql_equi_join.php on line 50

Warning: include(../google/ad.php): failed to open stream: No such file or directory in /home/java8s/public_html/oracle/sql/sql_equi_join.php on line 61

Warning: include(../google/ad.php): failed to open stream: No such file or directory in /home/java8s/public_html/oracle/sql/sql_equi_join.php on line 61

Warning: include(): Failed opening '../google/ad.php' for inclusion (include_path='.:/opt/cpanel/ea-php56/root/usr/share/pear') in /home/java8s/public_html/oracle/sql/sql_equi_join.php on line 61

Equi join:

To find out the employee's department name we compare the value in the dept-id column in the emp table with the dept-id value in the dept table. The relationship between the emp and dept tables is an equi join. That is the value in the dept-id column on both tables must be equal. This type join envolves primary key and foreign key compliments. Equi join are also called as simple joins or inner joins.

Example:

Select emp.emp-id, emp.emp-name, emp.dept-id, dept.dept-id, dept.location-id
From emp, dept
Where emp.dept-id = dept.dept-id ;
In the above example:

Note:-


Warning: include(../google/footer-ad.php): failed to open stream: No such file or directory in /home/java8s/public_html/oracle/sql/sql_equi_join.php on line 98

Warning: include(../google/footer-ad.php): failed to open stream: No such file or directory in /home/java8s/public_html/oracle/sql/sql_equi_join.php on line 98

Warning: include(): Failed opening '../google/footer-ad.php' for inclusion (include_path='.:/opt/cpanel/ea-php56/root/usr/share/pear') in /home/java8s/public_html/oracle/sql/sql_equi_join.php on line 98

Warning: include(../google/side-ad.php): failed to open stream: No such file or directory in /home/java8s/public_html/oracle/sql/sql_equi_join.php on line 105

Warning: include(../google/side-ad.php): failed to open stream: No such file or directory in /home/java8s/public_html/oracle/sql/sql_equi_join.php on line 105

Warning: include(): Failed opening '../google/side-ad.php' for inclusion (include_path='.:/opt/cpanel/ea-php56/root/usr/share/pear') in /home/java8s/public_html/oracle/sql/sql_equi_join.php on line 105

Warning: include(../footer.php): failed to open stream: No such file or directory in /home/java8s/public_html/oracle/sql/sql_equi_join.php on line 116

Warning: include(../footer.php): failed to open stream: No such file or directory in /home/java8s/public_html/oracle/sql/sql_equi_join.php on line 116

Warning: include(): Failed opening '../footer.php' for inclusion (include_path='.:/opt/cpanel/ea-php56/root/usr/share/pear') in /home/java8s/public_html/oracle/sql/sql_equi_join.php on line 116