Sams Teach Yourself SQL in 21 Days, Fourth Edition

Applying Query Concepts

Before going any further, look at the sample database that is the basis for the following examples. This database illustrates the basic functions of SELECT and FROM. In the real world, you would use the techniques described on Day 11, “Manipulating Data,” to build this database, but for the purpose of describing how to use SELECT and FROM, assume it already exists. This example uses the CHECKS table to retrieve information about checks that an individual has written.

The CHECKS table in Oracle:

 CHECK# PAYEE AMOUNT REMARKS ------ ------------------ ------- ------------------- 1 Ma Bell 150 Have sons next time 2 Reading R.R. 245.34 Train to Chicago 3 Ma Bell 200.32 Cellular Phone 4 Local Utilities 98 Gas 5 Joes Stale $ ...