MySQL CROSS JOIN Filtered 24-row Sample Output

Three sales rows have p_id 2. Each qualifying sales row is paired with all eight products, producing 24 combinations.

SELECT p.p_id, p.product AS catalog_product,
       s.sale_id, s.p_id AS sale_p_id, s.product AS sold_product, s.qty
FROM products AS p
CROSS JOIN sales AS s
WHERE s.p_id = 2
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	4	4	2	RAM	2	DEF
1	Hard Disk	80	7	2	2	RAM	3	ABC
1	Hard Disk	80	8	3	2	RAM	2	DEF
2	RAM	90	4	4	2	RAM	2	DEF
2	RAM	90	7	2	2	RAM	3	ABC
2	RAM	90	8	3	2	RAM	2	DEF
3	Monitor	75	4	4	2	RAM	2	DEF
3	Monitor	75	7	2	2	RAM	3	ABC
3	Monitor	75	8	3	2	RAM	2	DEF
4	CPU	55	4	4	2	RAM	2	DEF
4	CPU	55	7	2	2	RAM	3	ABC
4	CPU	55	8	3	2	RAM	2	DEF
5	Keyboard	20	4	4	2	RAM	2	DEF
5	Keyboard	20	7	2	2	RAM	3	ABC
5	Keyboard	20	8	3	2	RAM	2	DEF
6	Mouse	10	4	4	2	RAM	2	DEF
6	Mouse	10	7	2	2	RAM	3	ABC
6	Mouse	10	8	3	2	RAM	2	DEF
7	Motherboard	50	4	4	2	RAM	2	DEF
7	Motherboard	50	7	2	2	RAM	3	ABC
7	Motherboard	50	8	3	2	RAM	2	DEF
8	Power supply	20	4	4	2	RAM	2	DEF
8	Power supply	20	7	2	2	RAM	3	ABC
8	Power supply	20	8	3	2	RAM	2	DEF

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: 24-row Filtered Sample Output

Subhendu Mohapatra