• Shuffle
Toggle On
Toggle Off
• Alphabetize
Toggle On
Toggle Off
• Front First
Toggle On
Toggle Off
• Both Sides
Toggle On
Toggle Off
Toggle On
Toggle Off
Front

### How to study your flashcards.

Right/Left arrow keys: Navigate between flashcards.right arrow keyleft arrow key

Up/Down arrow keys: Flip the card between the front and back.down keyup key

H key: Show hint (3rd side).h key

A key: Read text to speech.a key

Play button

Play button

Progress

1/9

Click to flip

### 9 Cards in this Set

• Front
• Back
 Define alias and the format Used for simplifying the column and table name. Alias can be anything like the first character of the name or its short form etc. Format: Select column_name as column alias From table name as table alias Define the primary key in join function Primary key refers to the unique values for each row like employee ID, product ID etc. How to join two tables? To join two tables, at least one table must have the primary key which must also appear in another table that we want to join together How to select name from employee table and product from product table by joing two tables together? Select employee.name, product.product From employee, product Where employee.ID = product.ID How to use inner join to select name from employee table and product from product table? Select employee.name, product.product From employee inner join product On employee.ID = product.ID What is the difference between inner join, left join, and right join? Inner join - only show the rows which primary key match another row in another table Left join - will show all the rows of the first table even though the primary key doesn't match the row with another table Right join - show all the rows of the second table even though their primary key do not match with the row of another table Define union function Union is used to select the data from two tables. But it will include all data into one column which you firstly specify at the select statement. And it only select the unique value; it will not repeat the data twice if it appears more than once at the table. Define union all Same as union but it will select all values including the repeated ones. Union format Select column name from table 1 name Union Select column name from table 2 name