JOINS
JOINS Ø It is used to join rows in one table to rows in another table. Ø Join condition we will use in where clause Ø If join involves more than one table oracle 1 st joins 1 st two tables based on condition and then compare the result with next table and so on. Ø Using table alias names in join, ex: - Select * from emp e, dept d where e.deptno=d.deptno; Ø Types of joins 1.EQUI JOIN 2.INNER JOIN 3.NON EQUI JOIN 4.SELF JOIN 5.CARTESIAN JOIN OR CROSS JOIN OR CARTESIAN PRODUCT 6.OUTER JOIN 7.NATURAL JOIN 1. EQUI JOIN Ø Based on equality condition tables are joined, only matching records are displayed, to join tables both the tables must have at least one common col with same datatype and same values but col name may be different. Ø Select * from emp e, dept d where e.deptno=d.deptno; 2. INNER JOIN Ø Inner join will also work as same as equi join. Ø We use on clause for inner join Ø...