SQL QuickStart Guide

SELECT
*
FROM
invoices
INNER JOIN
customers
ON
invoices.CustomerId = customers.CustomerId

joins allow us to access fields from different tables.

ices with customer names.

A JOIN clause merging both of these tables together would look like this:

SELECT
*
FROM
invoices
INNER JOIN
customers
ON
invoices.CustomerId = customers.CustomerId

When querying with dates, use the same operators used when querying with numbers: =, >, <, BETWEEN, etc.

When querying for dates, it is important to first take a look at how the date is stored in the table you are querying

WHERE
InvoiceDate = '2009-01-03 00:00:00'

WHERE
BillingCity NOT LIKE '%T%'
ORDER BY
Total

WHERE
BillingCity LIKE '%T%'
ORDER BY
Total

SELECT InvoiceDate, BillingAddress, BillingCity, Total FROM invoices WHERE BillingCity LIKE 'T%' ORDER BY Total

Wildcard characters will always be enclosed in single quotation marks. Without quotation marks, % is an arithmetic operator known as modulo,