repeating-sql/select-from-invoice-6.2.sql at main · Bujhm/repeating-sql · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
/*
Created by: Ihor Semeniuk
Create Date: 07/12/2023
Decscription: JOINS, Simplifying using alises AS "i" or AS "c" for Invoice or Customer respectively
*/
SELECT
    c.FirstName,
    c.LastName,
    i.InvoiceId,
    i.CustomerId,
    i.InvoiceDate,
    i.Total
FROM
	Invoice AS i
JOIN
	Customer AS c ON i.CustomerId = c.CustomerId
ORDER BY
    c.CustomerId