What is the difference between a subquery and a join? Under what circumstances would you not be able to use a subquery?
What will be an ideal response?
With a subquery, the columns specified in the SELECT list are restricted to one table. Thus,
cannot use a subquery if the SELECT list contains columns from more than one table.
Computer Science & Information Technology
You might also like to view...
Setting the BorderStyle property to Outset makes a control appear ______.
a) raised b) with a bold border c) with the specified border width d) with the specified border color
Computer Science & Information Technology
USB stands for ____________________.
Fill in the blank(s) with the appropriate word(s).
Computer Science & Information Technology