Computer Notes

Header Right

Home » Sql » Commands » SQL CROSS JOIN

SQL CROSS JOIN

By Dinesh Thakur

A cross join, or product provides the foundation upon which all types of inner joins operate. A cross join returns the Cartesian product of the sets of records from the two joined tables. Thus, it equates to an inner join where the join-condition always evaluates to true or join-condition is absent in statement. This command is introduced for Oracle9i. If A and B are two sets, then the cross join is written as A x B.

Example: SQL> SELECT ENAME, DEPT.DEPTNO FROM EMP CROSS JOIN DEPT;

Explanation: After execution this command will return all the employees multiplied the departments. And it will again return 56 rows.

 

You’ll also like:

  1. SQL Self JOIN
  2. SQL INNER JOIN
  3. SQL RIGHT JOIN Keyword
  4. SQL LEFT OUTER JOIN
  5. SQL FULL OUTER JOIN Keyword
Like/Subscribe us for latest updates     
About Dinesh Thakur
Dinesh ThakurDinesh Thakur holds an B.C.A, MCDBA, MCSD certifications. Dinesh authors the hugely popular Computer Notes blog. Where he writes how-to guides around Computer fundamental , computer software, Computer programming, and web apps.

Dinesh Thakur is a Freelance Writer who helps different clients from all over the globe. Dinesh has written over 500+ blogs, 30+ eBooks, and 10000+ Posts for all types of clients.


For any type of query or something that you think is missing, please feel free to Contact us.