Question: Question 3 Data in a database is stored in separate tables, where each table stores a certain type of information. A join allows you to

Question 3 Data in a database is stored in separate tables, where each table stores a certain type of information. A join allows you to write a query that gets information from two or more tables and view the columns in a single set of results. Consider the tables A and B below and answer the questions that follow. Table A Table B 3.1. Briefly explain INNER and OUTER JOINs and differentiate between INNER and OUTER JOINs (6 Marks) 3.2. Write the SQL queries to perform an INNER JOIN of the tables and show the output of the joining. (7 Marks) 3.3. Write the SQL queries to perform left OUTER JOIN of the tables and show the output of the joining. (7 Marks)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
