Joins

Question 1

Inner Join

Answer 1

Produces only the set of records that match in both Table A and Table B.

Question 2

Full Outer Join

Answer 2

Produces the set of all records in Table A and Table B while matching the records from both sides where available. If there is no match, the missing sides on each table will contain null.

Question 3

Left Outer Join

Answer 3

produces a complete set of records from Table A, and matching records in Table B. If Table B has no matching record, in the specified row of Table A, it will contain null in that row for Table B.

Question 4

What is a self join?

Answer 4

A self join is an instance of a table joining itself.