Term
| What kind of SQL statment is a Inner Join? |
|
Definition
SELECT * FROM employee INNER JOIN department
ON employee.DepartmentID = department.DepartmentID; |
|
|
Term
| What kind of SQL statement is Left Outer Join? |
|
Definition
|
SELECT * FROM employee LEFT OUTER JOIN department
ON employee.DepartmentID = department.DepartmentID; |
|
|
Term
| What kind of SQL statement is a Full Outer Join? |
|
Definition
|
SELECT * FROM employee FULL OUTER JOIN department
ON employee.DepartmentID = department.DepartmentID; |
|
|
Term
| What SQL Statement is a Cross Join? |
|
Definition
| SELECT * FROM employee CROSS JOIN department; |
|
|
