SQLize - format run and share SQL queries online

CROSS JOIN

Tags: MySQL 5.7 MySQL 8.0 MariaDB 10 SQLite 3 PostgreSQL 11 PostgreSQL 12 PostgreSQL 13 PostgreSQL 14 PostgreSQL 15 MS SQL Server 2017 MS SQL Server 2019 MS SQL Server 2022 Oracle Database 19c Oracle Database 19c (HR) Oracle Database 21c

The CROSS JOIN is used to generate a paired combination of each row of the first table with each row of the second table. This join type is also known as cartesian join.

If WHERE clause is used with CROSS JOIN, it functions like an INNER JOIN.

The below code returns all combination Meals with all Drinks

CROSS JOIN - Popular snippets

PostgreSQL 14 CREATE TABLE PRIMARY KEY NOT DEFAULT INSERT INTO IN SELECT CROSS JOIN ORDER BY JOIN last run: 2022-03-22 18:18:24
3
PostgreSQL 14 CREATE TABLE PRIMARY KEY NOT DEFAULT INSERT INTO SELECT CROSS JOIN ORDER BY ORDER BY JOIN last run: 2022-03-22 18:07:45
3
MySQL 5.7 CREATE TABLE PRIMARY KEY INSERT INTO SELECT CROSS JOIN WHERE BETWEEN AND COUNT SUM INNER JOIN GROUP BY last run: 2022-11-11 17:46:59
2
PostgreSQL 14 CREATE TABLE PRIMARY KEY NOT DEFAULT INSERT INTO SELECT CROSS JOIN ORDER BY ORDER BY JOIN last run: 2022-03-22 18:09:30
2
PostgreSQL 14 CREATE TABLE PRIMARY KEY NOT DEFAULT INSERT INTO SELECT CROSS JOIN ORDER BY ORDER BY JOIN last run: 2022-03-22 18:08:27
2
PostgreSQL 14 CREATE TABLE PRIMARY KEY NOT DEFAULT INSERT INTO IN SELECT CROSS JOIN ORDER BY ORDER BY JOIN last run: 2022-03-22 18:13:52
1
PostgreSQL 14 CREATE TABLE PRIMARY KEY NOT DEFAULT INSERT INTO IN SELECT CROSS JOIN ORDER BY ORDER BY JOIN last run: 2022-03-22 18:12:05
1
PostgreSQL 14 CREATE TABLE PRIMARY KEY NOT DEFAULT INSERT INTO IN SELECT CROSS JOIN ORDER BY ORDER BY JOIN last run: 2022-03-22 18:11:45
1
PostgreSQL 14 CREATE TABLE PRIMARY KEY NOT DEFAULT INSERT INTO IN SELECT CROSS JOIN ORDER BY ORDER BY JOIN last run: 2022-03-22 18:11:25
1
PostgreSQL 14 CREATE TABLE PRIMARY KEY NOT DEFAULT INSERT INTO IN SELECT CROSS JOIN ORDER BY ORDER BY JOIN last run: 2022-03-22 18:11:15
1

CROSS JOIN - New snippets

MySQL 5.7 CREATE TABLE PRIMARY KEY INSERT INTO SELECT CROSS JOIN WHERE BETWEEN AND COUNT SUM INNER JOIN GROUP BY added at: 2022-11-11 17:46:59
2
PostgreSQL 14 CREATE TABLE PRIMARY KEY NOT DEFAULT INSERT INTO IN SELECT CROSS JOIN ORDER BY JOIN added at: 2022-03-22 18:14:16
3
PostgreSQL 14 CREATE TABLE PRIMARY KEY NOT DEFAULT INSERT INTO IN SELECT CROSS JOIN ORDER BY ORDER BY JOIN added at: 2022-03-22 18:13:52
1
PostgreSQL 14 CREATE TABLE PRIMARY KEY NOT DEFAULT INSERT INTO IN SELECT CROSS JOIN ORDER BY ORDER BY JOIN added at: 2022-03-22 18:12:05
1
PostgreSQL 14 CREATE TABLE PRIMARY KEY NOT DEFAULT INSERT INTO IN SELECT CROSS JOIN ORDER BY ORDER BY JOIN added at: 2022-03-22 18:11:45
1
PostgreSQL 14 CREATE TABLE PRIMARY KEY NOT DEFAULT INSERT INTO IN SELECT CROSS JOIN ORDER BY ORDER BY JOIN added at: 2022-03-22 18:11:25
1
PostgreSQL 14 CREATE TABLE PRIMARY KEY NOT DEFAULT INSERT INTO IN SELECT CROSS JOIN ORDER BY ORDER BY JOIN added at: 2022-03-22 18:11:15
1
PostgreSQL 14 CREATE TABLE PRIMARY KEY NOT DEFAULT INSERT INTO IN SELECT CROSS JOIN ORDER BY ORDER BY JOIN added at: 2022-03-22 18:11:00
1
PostgreSQL 14 CREATE TABLE PRIMARY KEY NOT DEFAULT INSERT INTO SELECT CROSS JOIN ORDER BY ORDER BY JOIN added at: 2022-03-22 18:09:28
2
PostgreSQL 14 CREATE TABLE PRIMARY KEY NOT DEFAULT INSERT INTO SELECT CROSS JOIN ORDER BY ORDER BY added at: 2022-03-22 18:08:43
1

SQLize.online - Popular functions

CREATE TABLE

154k

SELECT

151k

INSERT INTO

141k

WHERE

94k

PRIMARY KEY

93k

NOT

77k

AND

47k

FOREIGN KEY

42k

CONSTRAINT

41k

JOIN

37k

GROUP BY

37k

COUNT

35k

DROP TABLE

35k

AUTO_INCREMENT

35k

DEFAULT

31k

ORDER BY

30k

WITH

25k

INNER JOIN

23k

LEFT

21k

UPDATE

18k

15k

SUM

14k

CREATE VIEW

13k

DELETE

12k

ALTER TABLE

11k

DROP VIEW

10k

BETWEEN

CREATE PROCEDURE

DROP PROCEDURE

HAVING

CASE

ROW_NUMBER

EXEC

SHOW

RIGHT

CONCAT

MONTH

ADD CONSTRAINT

LAG

CREATE FUNCTION

CREATE OR REPLACE FUNCTION

COALESCE

OUTER JOIN

LEAD

TRUNCATE

ADD COLUMN

DENSE_RANK

CROSS JOIN

TRIM

999

SUBSTRING

972

LENGTH

945

LOWER

742

REPLACE

738

INSERT INTO

627

DROP COLUMN

606

INSERT INTO

531

DESCRIBE

510

UPPER

456

SUBSTR

428

LEFT JOIN

359

CREATE OR REPLACE PROCEDURE

359

INNER JOIN

310

REVERSE

300

JSON_CONTAINS

263

DROP CONSTRAINT

257

ADD CONSTRAINT

236

JSON_ARRAY

215

DROP FUNCTION

183

INSERT INTO

174

IFNULL

164

INSERT INTO

146

PRIMARY KEY

138

JSON_AGG

132

LTRIM

106

NULLIF

GROUP BY

CREATE OR REPLACE TRIGGER

LPAD

RTRIM

ORDER BY

ADD COLUMN

ADD CONSTRAINT

CREATE OR REPLACE FUNCTION

CREATE OR REPLACE VIEW

DROP TABLE

DROP INDEX

INSERT INTO

DROP TRIGGER

INSERT INTO

CROSS JOIN

UUID_GENERATE_V4

INSERT INTO

ADD CONSTRAINT

RPAD

CREATE OR REPLACE FUNCTION

GROUP BY

DROP SEQUENCE

DROP FUNCTION

our telegram chat
PHP versions:
Warning: implode(): Invalid arguments passed in /code/templates_c/c20a124ec93441b64cbdf93bf5e1b7211243ec47_0.file.footer.tpl.php on line 37

RDBMS versions:
Warning: implode(): Invalid arguments passed in /code/templates_c/c20a124ec93441b64cbdf93bf5e1b7211243ec47_0.file.footer.tpl.php on line 39

SQLize Online / PHPize Online

CROSS JOIN - Popular snippets

CROSS JOIN - New snippets

SQLize.online - Popular functions