Just trying to wrap my head around the use of subqueries. Is it correct to say that they come in three main categories:
- Scalar: returns a single value
- Table-valued: Returns a table, to compare or add to the outer query.
- Correlated: Cannot be run as a stand-alone, must make use of data from outer query in order to run, to be executed.
Is this correct, or are there more categories? Or some subdivisions within the ones I wrote? Of course, there is, I guess, a degree of idiosyncrasy here.