ON
i. CustomerId = c.CustomerId
Правое внешнее соединение (не поддерживается в SQLite)
SELECT
i. InvoiceId,
c. CustomerId,
c. Name,
c. Address,
i. InvoiceDate,
i. BillingAddress,
i. Total
FROM
invoices AS i
RIGHT OUTER JOIN — Меняет местами таблицы
customers AS c
ON i.CustomerId = c.CustomerId
SELECT
ar.ArtistId AS [ArtistId From Artists Table],
al.ArtistId AS [ArtistId From Albums Table],
ar.Name AS [Artist Name],