Monthly Archives: January 2012

  Multiple-Table queries   You can make multiple-table queries shorter and more readable by assigning aliases to the tables in a SELECT statement. An alias is a word that immediately follows the name of a table in the FROM clause. … Continue reading →

Selecting Specific Columns   Often all you want to see is the data in one or more specific columns. Again, the formula is to use the SELECT and FROM clauses, specify the columns and table, and perhaps order the data … Continue reading →

You can query a single table in a database in many ways. You can tailor a SELECT statement to perform the following actions: Retrieve all or specific columns Retrieve all or specific rows 3. Perform computations or other functions on … Continue reading →