Introduction to SQL

(e) CROSS JOIN:- the cross join clause is used in the cross join concept which produces the cross product of two tables. E.g.:-select ename ,dname. from emp. cross join dept; (f) NATURAL JOIN:- it was not possible to do a join with out explicitly specifying the columns in the corresponding tables in prior release of oracle. ................
................