SQLize - format run and share SQL queries online

CROSS JOIN

Tags: MySQL 5.7 MySQL 5.7 (Sakila - ReadOnly) MySQL 8.0 MySQL 8.0 (Sakila - ReadOnly) MariaDB 10 MariaDB 10 (Sakila - ReadOnly) 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 (HR) Oracle Database 21c Oracle Database 23c Free SOQOL (beta)

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
MySQL 5.7 CREATE TABLE NOT PRIMARY KEY AUTO_INCREMENT FOREIGN KEY INSERT INTO SELECT CROSS JOIN last run: 2023-04-21 12:55:37
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: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

CROSS JOIN - New snippets

MySQL 5.7 CREATE TABLE NOT PRIMARY KEY AUTO_INCREMENT FOREIGN KEY INSERT INTO SELECT CROSS JOIN added at: 2023-04-21 12:55:37
1
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

SQLize.online - Popular functions

SELECT

239k

CREATE TABLE

237k

INSERT INTO

214k

WHERE

143k

PRIMARY KEY

137k

NOT

120k

AND

73k

FOREIGN KEY

63k

JOIN

60k

GROUP BY

59k

ORDER BY

56k

CONSTRAINT

55k

COUNT

51k

AUTO_INCREMENT

47k

WITH

46k

DROP TABLE

45k

DEFAULT

44k

INNER JOIN

32k

LEFT

31k

UPDATE

28k

SUM

25k

DELETE

20k

CREATE VIEW

17k

ALTER TABLE

16k

15k

HAVING

14k

BETWEEN

13k

DROP VIEW

12k

CASE

12k

CREATE PROCEDURE

10k

ROW_NUMBER

DROP PROCEDURE

MONTH

EXEC

SHOW

RIGHT

CONCAT

LAG

ADD CONSTRAINT

CREATE FUNCTION

CREATE OR REPLACE FUNCTION

COALESCE

LEAD

OUTER JOIN

CROSS JOIN

DENSE_RANK

ADD COLUMN

TRUNCATE

INSERT INTO

SUBSTRING

UPPER

LENGTH

REPLACE

TRIM

LOWER

CREATE OR REPLACE VIEW

992

CREATE OR REPLACE PROCEDURE

934

DROP COLUMN

931

INSERT INTO

878

JSON_CONTAINS

866

DESCRIBE

733

SUBSTR

719

IFNULL

695

LEFT JOIN

491

INSERT INTO

456

REVERSE

395

JSON_ARRAY

337

INNER JOIN

315

DROP CONSTRAINT

313

ADD CONSTRAINT

298

UUID_GENERATE_V4

279

DROP FUNCTION

255

INSERT INTO

228

CREATE OR REPLACE TRIGGER

218

NULLIF

206

ORDER BY

205

LTRIM

171

RTRIM

144

JSON_AGG

144

PRIMARY KEY

138

LPAD

119

GROUP BY

110

DAYOFWEEK

104

DROP TRIGGER

INSERT INTO

ADD COLUMN

ADD CONSTRAINT

CREATE OR REPLACE FUNCTION

RPAD

ROW_TO_JSON

DROP INDEX

CREATE TABLE

DROP TABLE

DROP SEQUENCE

INSERT INTO

CROSS JOIN

ADD CONSTRAINT

our telegram chat
PHP versions: PHP 5.6, PHP 7.4, PHP 8.0, PHP 8.1, PHP 8.2.3
RDBMS versions: MySQL 5.7, MySQL 5.7 (Sakila - ReadOnly), MySQL 8.0, MySQL 8.0 (Sakila - ReadOnly), MariaDB 10, MariaDB 10 (Sakila - ReadOnly), 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 (HR), Oracle Database 21c, Oracle Database 23c Free, SOQOL (beta)

SQLize Online / PHPize Online

CROSS JOIN - Popular snippets

CROSS JOIN - New snippets

SQLize.online - Popular functions