SQL-complete-tutorial

1
USE sql_store;
2

3
SELECT 
4
	c.first_name AS customer,
5
    p.name AS product
6
FROM customers c
7
CROSS JOIN products p -- this is the explicit syntax for a cross join
8
ORDER BY c.first_name;
9

10
SELECT 
11
	c.first_name AS customer,
12
    p.name AS product
13
FROM customers c, products p -- this is the equivalent to the explicit syntax's result
14
ORDER BY c.first_name;
15

16
-- Do a cross join between shippers and products
17
-- using the implicit syntax
18
-- and then using the explicit syntax
19

20
-- implicit syntax of CROSS JOIN
21
SELECT 
22
	sh.name AS shippers,
23
    p.name AS products
24
FROM shippers sh, products p
25
ORDER BY sh.name;
26

27
-- explicit syntax of CROSS JOIN
28
SELECT 
29
	sh.name AS shippers,
30
    p.name AS products
31
FROM shippers sh
32
CROSS JOIN products p
33
ORDER BY sh.name;