JOINS

Question 1

Outer Joins

Answer 1

rows from tables are returned even if they dont match

Question 2

FULL Join (outer joins)

Answer 2

1. returns rows from both tables even if they dont match the join statement
   example : find customer without orders or orphaned orders

Question 3

LEFT or RIGHT (Outer join)

Answer 3

1. no difference except in order of tables in FROM clause

2. direction points at table to retrieve non - matching rows

Question 4

Cross Joins

Answer 4

1. All rows match from each table (no ON statement)

2. also known as cartesian product