Shared Flashcard Set

Details

ACCT 371B - SQL Clauses
The different clauses we need to know for Quiz 2
4
Accounting
Undergraduate 3
11/28/2012
Click here to study/print these flashcards.

Create your own flash cards! Sign up here.

Additional Accounting Flashcards

 

 

Cards

Term
Select
 Definition

Shows fields to be displayed

 

Format: SELECT Table.Field Name

More than 1: SELECT Table.Field Name, Table2.FN2

 

Anything with a space in it needs brackets

Table.[Field Name]
Term
From
 Definition

Which table columns belong to

 

From Table1 INNERJOIN Table2 ON Table1.[Joining Field] = Table2.[Joining Field]
Term
Where
 Definition

Adds search condition to SQL statement

 

WHERE (((Table.[Field Name]) Like "Condition"))

 

* = anything after the previous condition ("Ch*")

Can do Like or =
Term
Order By
 Definition

Determines order of data

 

Order By Table.field DESC

- Orders descending

 

Can have multiple orderings if more than 1 field
Supporting users have an ad free experience!