Which JOIN returns only the matching rows from both tables?  1 pointINNER JOINLEFT JOINRIGHT JOINFULL OUTER JOIN

Which join types return all rows from only one of the tables being joined? Select all that apply.1 pointFULL OUTER JOINRIGHT JOININNER JOINLEFT JOIN

Question 1Which of this type of join returns an output of only matching records in the two tables? (Select all that apply)1 pointFULL JOINJOININNER JOINLEFT JOIN

Which of these is true of LEFT JOIN? (Select all that apply)1 pointAll records from the left table that have no matching record from the right table.It returns all matching records in both tablesAll records from the right table

Question 20When creating a SQL query, which JOIN clause returns all matching records in two or more database tables?1 pointLEFTRIGHTINNEROUTER

What type of JOIN returns all rows when there is a match in ONE of the tables?