The WHERE clause also can take multiple conditions. To search for Ben Forta, for example, you can specify a search condition in which the first name is Ben and the last name is Forta, as shown in Listing 6.8. As Figure 6.11 shows, only Ben Forta is retrieved.
SELECT FirstName, LastName, Email FROM Contacts WHERE FirstName='Ben' AND LastName='Forta'
Text passed to a SQL query must be enclosed within quotation marks. If you omit the quotation marks, the SQL parser thinks ...