Now, switch to SQL view, as shown in Figure 4-2.
Note that the derived SQL statement consists of two parts.
First there is the SELECT followed by the field we selected,
then the FROM showing which table was used for the select.
Look at the following syntax for the SELECT statement:
SELECT Columnname(s) FROM TableName(s);
The SELECT keyword is used by SQL to specify what data is
desired from a table. The FROM keyword tells SQL what table
the columns come from.
51
3
Retrieving Records
Figure 4-1
Figure 4-2
|
|