Linq Select Subquery

Dim db as new DataBaseDataContext

Dim query = from p in db.products _
select .category_name = (from c in db.category where p.category_id = p.category_id select c.category_name).first