SQL Joins

What is the most common JOIN statement used in business?

• Inner Join

• Left Join

• Right Join

• Full Outer Join

Which join would you use to create a query that returns ALL data from Table B and only those on Table A that match?

• Inner Join

• Left Join

• Right Join

• Full Outer Join