Question: database question When joining two tables, we use WHERE clause to restrict the result to rows that have common values in matching columns. TRUEFALSE 1-

database question
When joining two tables, we use WHERE clause to restrict the result to rows that have common values in matching columns. TRUEFALSE 1- 2- When joining two tables, we have to qualify the PK of both tables. TRUE FALSE 3- When using subquery, both results of the outer (main query) and the inner (subquery) will be displayed. TRUE FALSE When using subquery with IN operator, the subquery is called correlated subquery because it involves a table listed in the outer query (main query). TRUE FALSE ) 4- When joining a table to itself, we MUST use the original name of the table to qualify common columns instead of the alias name of the table. TRUE FALSE) 5
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
