What is the difference between a sub query and a join? Under what circumstances would you not be able to use a sub query?

      

What is the difference between a sub query and a join? Under what circumstances would you not be able to use a sub query?

  

Answers


kelvin
With a sub query, the columns specified in the SELECT list are restricted to one table. Thus, cannot use a sub query if the SELECT list contains columns from more than one table
kevowmuchiri answered the question on July 4, 2018 at 15:42


Next: Explain how the GROUP BY clause works. What is the difference between the WHERE and HAVING clauses?
Previous: What is QBE and what is the relationship between QBE and SQL?

View More Computer Science Questions and Answers | Return to Questions Index


Exams With Marking Schemes

Related Questions