Select SubQuery

A SubQuery in a Select clause must return a single value.

C#

VB

Produces the following SQL

This is the same as the query above, but returns all columns in the Order table, instead of just OrderID and OrderDate. Notice that the Select clause contains orders, not orders.*. The SQL produced will use the supplied alias o.*.

C#

VB

Produces the following SQL