1. Provide two examples of Inner joins. For your examples, show the contents of each table, then show the results of the join. Would any other SQL statement provide the same results? If so, include it in your response.
2. Provide two examples of Outer joins. For your examples, show the contents of each table, then show the results of the join. Would any other SQL statement provide the same results? If so, include it in your response.
3. Provide two examples of Left/right joins. For your examples, show the contents of each table, then show the results of the join. Would any other SQL statement provide the same results? If so, include it in your response.

Answer rating: 100% (QA)

Lets go through examples of Inner joins Outer joins and LeftRight joins Example 1 Inner Join Consider two tables Table Customers CustomerID Name 1 Joh... View the full answer