join

It will return an aggregate row with a member of type of each table in the join.

Could do an anonymous object for other things in the sql...

join
(
TableA
TableB
ThroughTable = void
)
()

Meta