Add criteria

Up to this point, you've only queried from one table. Now use multiple tables in a query:

  1. Type:

    SELECT quote,last FROM quote,name WHERE quote.name_id=name.id ORDER BY last;

    then press ENTER.

    The query results should look like this:

    This query lists all of the quotes FROM the quote table, along with the last names of the presidents (pulled from the name table) who said them.

Want ad-free tutorials like these for classroom use? Get them at Visilearn.com.