How do I create a SQL join query using multiple DataTables?

[Christhemist]

It's not letting me select more than one field, am I missing something in the syntax below?

Dim both = From row1 In AddressListDatatable.AsEnumerable()
                   Join row2 In Matrix1Datatable.AsEnumerable()
                   On row1.Field(Of String)("Code") Equals row2.Field(Of String)("Code")
                   Select row1.Field(Of String)("FirstName")