F-J Flashcards
(13 cards)
1
Q
A constraint that is a key used to link two tables together
A
Foreign Key
2
Q
Specifies which table to select or delete data from
A
From
3
Q
Returns all rows when there is a match in either left table or right table
A
Full Outer Join
4
Q
Groups the result set (used with aggregate functions: Count Max Min Sum Avg
A
Group By
5
Q
Used instead of Where with aggregate functions
A
Having
6
Q
Allows you to specify multiple values in a Where clause
A
In
7
Q
Creates or Deletes an index in table
A
Index
8
Q
Returns rows that have matching values in both tables
A
Inner Join
9
Q
Inserts new rows in a table
A
Insert Into
10
Q
Copies data from one table into another table
A
Insert Into Select
11
Q
Tests for empty values
A
Is Null
12
Q
Test for non-empty values
A
Is Not Null
13
Q
Joins tables
A
Join
