Which of the following steps are necessary for a subquery to reference a column coming from the FROM clause in the outer query when the subquery has a column of the same name?A. Use TABLE.COLUMN or alias.COLUMN when referencing the column from the outer queryB. Ensure the same column is made available in the FROM clause of the subqueryC. Define the column available in the outer query in the outer query's SELECT clause.D. Ensure the column has an alias in the outer query.

Solved
Show answers

Ask an AI advisor a question