Which of the following statements is correct?
a. If a subquery is used in the outer query’s FROM clause, the data in the temporary table can’t be referenced by clauses used in the outer query.
b. The temporary table created by a subquery in the outer query’s FROM clause must be assigned a table alias, or it can’t be joined with another table by using the JOIN keyword.
c. If a temporary table is created through a subquery in the outer query’s FROM clause, the data in the temporary table can be referenced by another clause in the outer query.
d. None of the above