What is a join? Why do you need a join?

What is an INNER JOIN?

Which clause[s] can be used in place of the JOIN in Server SQL?

What is the Cartesian product?

What would be the Cartesian product of a table with 15 rows and another table with 23 rows?

List some uses of the Cartesian product.

What is an equi-join?

What is a non-equi-join? Give an example of an non-equi-join.

What is a self join? Give an example of a self join.

What is a LEFT OUTER JOIN?

What is a RIGHT OUTER JOIN?

What is a CROSS JOIN?

What is a FULL OUTER JOIN?

Does Server SQL allow the use of *= to perform outer joins?

What is the maximum number of rows that a self join can produce?

For what kinds of joins will the associative property hold?

What would be the Cartesian product of the two sets {a,b,c} and {c,d,e}?