Code example $19-2$

SELECT v$.$VendorName, i$.$InvoiceNumber, i$.$InvoiceDate, i$.$InvoiceTotal

FROM Vendors AS v

INNER JOIN Invoices AS i

ON v$.$VendorID $=$ i$.$VendorID

WHERE i$.$InvoiceTotal $>=500$

ORDER BY v$.$VendorName DESC

$($Refer to code example $19-2.)$ Each column in the SELECT statement is qualified to indicate which table the column belongs to$.$ One way to make it easier to qualify columns is to use for table names.

keywords

aliases

wildcards

joins