Join SubQuery

SubQueries cannot be used directly within a Join(SubQuery) clause, but they can be used within a Join(query).On(SubQuery) clause.

C#

VB

Produces the following SQL