Joins that show the matching rows from the joined tables plus ...

[Caiter2013]

Joins that show the matching rows from the joined tables plus unmatched rows from one other table in their results are called outer joins.
 
  Indicate whether the statement is true or false

Question 2

There is a common trap in writing a correlated subquery, which will cause no rows to ever be displayed in the results.
 
  Indicate whether the statement is true or false

[robbielu01]

Answer to Question 1

TRUE

Answer to Question 2

TRUE

[Caiter2013]

Thanks for the timely response, appreciate it

[xiazhe]

TYSM