Use Case for SQL Cross Joins

View All Scripts Login to Run Script

Script Name Use Case for SQL Cross Joins
Description https://pivotronics.com/ Here is the SQL script demonstrating the applications of Cross Joins in SQL.
Area SQL General / SQL Query
Contributor Balakrishna Sappa
Created Thursday December 08, 2016

Statement 1

CREATE TABLE TEAMS 
(
    TEAM_ID INT
    , TEAM_NAME VARCHAR2(100)
)

Table created.

Statement 2

INSERT INTO TEAMS (TEAM_ID, TEAM_NAME)
VALUES (1, 'Brazil')

1 row(s) inserted.

Statement 3

INSERT INTO TEAMS (TEAM_ID, TEAM_NAME)
VALUES (2, 'Italy')

1 row(s) inserted.

Statement 4

INSERT INTO TEAMS (TEAM_ID, TEAM_NAME)
VALUES (3, 'Argentina')

1 row(s) inserted.

Statement 5

INSERT INTO TEAMS (TEAM_ID, TEAM_NAME)
VALUES (4, 'Germany')

1 row(s) inserted.

Statement 6

SELECT * FROM TEAMS


TEAM_ID TEAM_NAME
1 Brazil
2 Italy
3 Argentina
4 Germany

4 rows selected.

Statement 7

SELECT A.TEAM_NAME AS TEAM_A, B.TEAM_NAME AS TEAM_B
FROM TEAMS A
CROSS JOIN TEAMS B
WHERE A.TEAM_ID < B.TEAM_ID


TEAM_A TEAM_B
Brazil Italy
Brazil Argentina
Brazil Germany
Italy Argentina
Italy Germany
Argentina Germany

6 rows selected.

Additional Information