Yes. But I have tons of fields. It's hard to write and maintain. I am just wondering a good way.

I have this query, but I need the flat result. Like: c.id, c.CoverCode, c.Premium, ..., cv.CoverageCode any idea??? From c In Covers _ Join cv In Coverages On c.PolicyKey Equals cv.PolicyKey And c.CoverNumber Equals cv.CoverNumber _ Where c.PolicyKey = 3441028 _ Select New With {c, cv.CoverageCode}

I have this query, but I need the flat result. Like c.id, c.CoverCode, c.Premium, ..., cv.CoverageCode any idea??? From c In Covers _ Join cv In Coverages On c.PolicyKey Equals cv.PolicyKey And c.CoverNumber Equals cv.CoverNumber _ Where c.PolicyKey = 3441028 _ Select New With {c, cv.CoverageCode}