Question: 12. Match the correct join with a good definition (only use each once) A. Cross join Joins each row in one table with Answer every
12. Match the correct join with a good definition (only use each once) A. Cross join Joins each row in one table with Answer every row in the other table oins two tables and returns all the Answer rows in the left hand table and only those in the right table that have matches (other unmatched rows return null from right table) B. Self join C. Left outer join Join made with two similiarly named Answer columns without specifically creating a join between the columns Join that matches rows in each table Answer on a particular column D. Inner join E. Right outer join Join that joins the matched and Answer unmatched rows from both tables (brings back nulls for unmatched rows from both tables) Joins two tables and returns all the rows in the right hand table and only those in the left table that have matches (other unmatched rows return null from left table) Join that joins a table with itself F. Full outer join Answer G. Natural join
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
