MySQL CROSS JOIN 72-row Sample Output

This page preserves the complete result set used by the main CROSS JOIN tutorial. Eight product rows combined with nine sales rows produce 72 row combinations.

SELECT p.p_id, p.product AS catalog_product, p.price,
       s.sale_id, s.p_id AS sale_p_id, s.product AS sold_product,
       s.qty, s.store
FROM products AS p
CROSS JOIN sales AS s
ORDER BY s.sale_id, p.p_id;

p_id	product	price	sale_id	c_id	p_id	product	qty	store
1	Hard Disk	80	1	2	3	Monitor	2	ABC
2	RAM	90	1	2	3	Monitor	2	ABC
3	Monitor	75	1	2	3	Monitor	2	ABC
4	CPU	55	1	2	3	Monitor	2	ABC
5	Keyboard	20	1	2	3	Monitor	2	ABC
6	Mouse	10	1	2	3	Monitor	2	ABC
7	Motherboard	50	1	2	3	Monitor	2	ABC
8	Power supply	20	1	2	3	Monitor	2	ABC
1	Hard Disk	80	2	2	4	CPU	1	DEF
2	RAM	90	2	2	4	CPU	1	DEF
3	Monitor	75	2	2	4	CPU	1	DEF
4	CPU	55	2	2	4	CPU	1	DEF
5	Keyboard	20	2	2	4	CPU	1	DEF
6	Mouse	10	2	2	4	CPU	1	DEF
7	Motherboard	50	2	2	4	CPU	1	DEF
8	Power supply	20	2	2	4	CPU	1	DEF
1	Hard Disk	80	3	1	3	Monitor	3	ABC
2	RAM	90	3	1	3	Monitor	3	ABC
3	Monitor	75	3	1	3	Monitor	3	ABC
4	CPU	55	3	1	3	Monitor	3	ABC
5	Keyboard	20	3	1	3	Monitor	3	ABC
6	Mouse	10	3	1	3	Monitor	3	ABC
7	Motherboard	50	3	1	3	Monitor	3	ABC
8	Power supply	20	3	1	3	Monitor	3	ABC
1	Hard Disk	80	4	4	2	RAM	2	DEF
2	RAM	90	4	4	2	RAM	2	DEF
3	Monitor	75	4	4	2	RAM	2	DEF
4	CPU	55	4	4	2	RAM	2	DEF
5	Keyboard	20	4	4	2	RAM	2	DEF
6	Mouse	10	4	4	2	RAM	2	DEF
7	Motherboard	50	4	4	2	RAM	2	DEF
8	Power supply	20	4	4	2	RAM	2	DEF
1	Hard Disk	80	5	2	3	Monitor	3	ABC
2	RAM	90	5	2	3	Monitor	3	ABC
3	Monitor	75	5	2	3	Monitor	3	ABC
4	CPU	55	5	2	3	Monitor	3	ABC
5	Keyboard	20	5	2	3	Monitor	3	ABC
6	Mouse	10	5	2	3	Monitor	3	ABC
7	Motherboard	50	5	2	3	Monitor	3	ABC
8	Power supply	20	5	2	3	Monitor	3	ABC
1	Hard Disk	80	6	3	3	Monitor	2	DEF
2	RAM	90	6	3	3	Monitor	2	DEF
3	Monitor	75	6	3	3	Monitor	2	DEF
4	CPU	55	6	3	3	Monitor	2	DEF
5	Keyboard	20	6	3	3	Monitor	2	DEF
6	Mouse	10	6	3	3	Monitor	2	DEF
7	Motherboard	50	6	3	3	Monitor	2	DEF
8	Power supply	20	6	3	3	Monitor	2	DEF
1	Hard Disk	80	7	2	2	RAM	3	ABC
2	RAM	90	7	2	2	RAM	3	ABC
3	Monitor	75	7	2	2	RAM	3	ABC
4	CPU	55	7	2	2	RAM	3	ABC
5	Keyboard	20	7	2	2	RAM	3	ABC
6	Mouse	10	7	2	2	RAM	3	ABC
7	Motherboard	50	7	2	2	RAM	3	ABC
8	Power supply	20	7	2	2	RAM	3	ABC
1	Hard Disk	80	8	3	2	RAM	2	DEF
2	RAM	90	8	3	2	RAM	2	DEF
3	Monitor	75	8	3	2	RAM	2	DEF
4	CPU	55	8	3	2	RAM	2	DEF
5	Keyboard	20	8	3	2	RAM	2	DEF
6	Mouse	10	8	3	2	RAM	2	DEF
7	Motherboard	50	8	3	2	RAM	2	DEF
8	Power supply	20	8	3	2	RAM	2	DEF
1	Hard Disk	80	9	2	3	Monitor	2	ABC
2	RAM	90	9	2	3	Monitor	2	ABC
3	Monitor	75	9	2	3	Monitor	2	ABC
4	CPU	55	9	2	3	Monitor	2	ABC
5	Keyboard	20	9	2	3	Monitor	2	ABC
6	Mouse	10	9	2	3	Monitor	2	ABC
7	Motherboard	50	9	2	3	Monitor	2	ABC
8	Power supply	20	9	2	3	Monitor	2	ABC

CROSS JOIN LEFT JOIN using Multiple Tables

← Back to CROSS JOIN tutorial

Subhendu Mohapatra

Author & Instructor at plus2net

I write and maintain practical tutorials on Python, PHP, SQL, JavaScript, HTML, jQuery, and web development at plus2net. The tutorials focus on clear explanations, working examples, and code that readers can test and adapt while learning.

About the author Watch on YouTube

Connect:

Subscribe to our YouTube Channel here

CROSS JOIN: Complete 72-row Sample Output

Subhendu Mohapatra