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...